Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to use For loop in script?

For loop in Qlikview script with ex.

2 Replies
tresesco
MVP
MVP

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

danansell42
Creator III
Creator III

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