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..