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:
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);