Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The article you are trying to access is permanently deleted.
For loop in Qlikview script with ex.
Have you checked qlik help ? For..next ‒ QlikView
//Spreadsheet containing expressions and variable name//
Expressions:
LOAD Variable,
Expression
FROM
(ooxml, embedded labels, table is Sheet1);
//Loop to load all expressions into variables//
Let vNumberOfRows = NoOfRows('Expressions');
For vI = 0 to (vNumberOfRows - 1)
Let vVariable_Name = Peek('Variable',vI,'Expression');
Let [$(vVariable_Name)] = Peek('Expression',vI,'Expression');
Next