Discussion Board for collaboration on QlikView Scripting.
It is possible to load a formated table to link with a loop in the script.
I have a ExcelTable with 52 sheets, For every week one sheet. So I must work with the control statement for and next.
Is the cross table is loaded without loop it works. If I load the crosstable with the loop the load has a failure.
See also the added example.
Please help! Thanks
First load all the data in a table using the loop and then create a new table using the crosstable function. Something like:
for i=1 to 52
load * from ...excelfile...
load * resident Temp;