This content has been marked as final. Show 5 replies
So I'm new to Qlik and can't find out why the following script won't work:
SET vStartColumn = 2003;
SET vEndColumn = 2007;
SET vExcelName = "Budget";
FOR i = vStartColumn TO vEndColumn
i AS Year, // This is where the error occurs.
"$(i)" AS Budget
(biff, embedded labels, header is 1 lines, table is $(vExcelName)$)
WHERE isnull("$(i)")=0 and "$(i)">0;
The issue as I see it is when I try to use i as a numerical input in the load script. Somehow Qlik tries to turn it into a field name.
How can I solve this issue?