Table arithmetic (AskiaAnalyse)

Table arithmetic allows you to define sophisticated scripts that affect the appearance of your table, or to add figures to the table, based on the table contents. There are two main types:

• Post-processing or cleaning scripts allow you to change the appearance of the figures in your tables, based on their values. They run immediately after your table is created. For example, you could have sophisticated conditional formatting, or enter text and numbers into specific table cells.
• Calculation arithmetic, which is a calculation type you can include in your tables, to alter the contents of the table based on the figures in the table, or another table in your portfolio.

In this topic:

• Cleaning (post-processing) scripts
  • Examples
• Calculation arithmetic
  • Examples

Cleaning (post-processing) scripts

You can add a cleaning script to your table by entering it in the sorting tab of the table settings.

To enter a cleaning script:

1. In the general tab of table definition, click settings....
2. Open the sorting tab.
3. In cleaning script, enter your script.
4. You can open a larger window in which you can enter your script. To do so, click .
5. Compile the script by clicking compile:
   

Cleaning script examples

An example of a cleaning script that replaces significance letters with colour-coded arrows can be found in the following article: AskiaAnalyse version 5.3.5.0 notes. A link to a portfolio and QES file containing the example tab template can be found in the article.

The knowledge base contains detailed examples of cleaning scripts:

• Cleaning script to replace all entries in a column with ‘-‘, if the base row is less than 50.
• Cleaning script to blank out all data (including the base row) in any column where the base is less than 50, and to change the format in columns where the base is between 50 and 100.
• Cleaning script to correct a specific brand's figures, for certain waves, by multiplying them by predetermined factors.
• Another example of correcting a specific brand's figures, for certain waves, by multiplying them by predetermined factors.

Calculation arithmetic

You can add calculation arithmetic to your table by adding a calculation arithmetic calculation to your table definition, and then by defining an appropriate script.

To enter a calculation arithmetic script:

1. In the general tab of table definition, look through the list of calculation types, locate calculation arithmetic, and check (select) it. If it is not in the list, right-click and select insert, and then select calculation arithmetic in calculation type, and click OK.
2. Right-click calculation arithmetic, and select properties.
3. Click script....
4. In the calculation arithmetic dialog, enter your script.
5. If you want the result of the calculation to appear at the bottom of the table (like a mean or median), select appears like a stat calculation.
6. If you want the result of the calculation to be a string, select result must be a string.

Calculation arithmetic examples

A worked example of table arithmetic can be found in the following article: AskiaAnalyse version 5.3.5.0 notes. A link to a portfolio and QES file containing the example can be found in the article.

The knowledge base contains detailed examples of cleaning scripts:

• A script to create a table based off another one, and, for each cell, performing the particular calculation: ((Sum of all scores in its column) * (Sum of all scores in its row)) / (Sum of all scores in table).
• A script to delete the text in a table after a given row, then fill from one table into another (e.g. to create a table that isolates and shows only the top ranked items in another table).
• How to use calculation arithmetic to work out averages.