topic how to use For loop in script? in QlikView

how to use For loop in script?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

For loop in Qlikview script with ex.

Re: how to use For loop in script?

tresB — Mon, 18 Dec 2017 12:21:09 GMT

Have you checked qlik help ? For..next ‒ QlikView

Re: how to use For loop in script?

danansell42 — Mon, 18 Dec 2017 12:25:20 GMT

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