Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Creating a new table in the load script


I was wondering how I should approach this issue the most efficient (performance wise):

1) In the 'Edit Script' section I uploaded a huge table AA with several columen (f.e. column A to Z) and with lets say 100.000 rows

2) I would like to use several selections of this table afterwards. For example a new table BB where the value of column A = 1. Now we created a new table with 80.000 rows...

Where should I create these new tables? Because I want to use this new table later to make selections etc in Qlikview itself. Obviously the selection is not that easy but is a slightly more complex SQL statement..

Thanks for your help!

Community Browser