Calculations and flags in the script

It's always a good idea to do as much work in the script as possible because the work only needs to be done once when the document is reloaded, not every time the user chooses a particular sheet or object.

Consider this requirement: products with prices between £10.00 and £19.99 need to be shown in a straight table with no other products visible. It would be easy enough to do this as an IF() statement in an expression:

We suppress zero values and hide the column. However, if there are several thousand rows, screen performance could be poor.

It would be better to do the work in the script if we can:

Product:
LOAD [Product Code], 
     [Supplier Product Code], 
     [Supplier No], 
     [Manufacturer Product Code], 
     [Manufacturer No], 
     [Short Description], 
     Kit, 
     Price,
     IF(Price > 9.99 AND Price < 20.00, 1, 0) AS [Check Price]
FROM
[..\QlikView Unlocked Data.xlsx]
(ooxml, embedded labels, table is Product); 

All we need to do now...