for loop

pk — Fri, 15 Nov 2024 23:25:25 GMT

Hi All,
Want to read QVD no of rows and add for loop and read the values from that file/QVD

want to count the no of rows and apply For loop till the count of Rows and print the values of Field1(QVDName) & Field2(Flag) in variables

I loaded this .txt file into qlikview and used below code to get the row counts from the table/file-
Let vCount = NoofRows(TablName/QvdName)-So in this case vCount will be 4.

So now how we can apply/add For loop till 4 and print the values ?

Thanks in advance!

Re: for loop

maxgro — Mon, 13 Dec 2021 13:26:25 GMT

try this

Let vCount = NoofRows('TableName');

FOR i=0 TO vCount-1

trace $(i);
LET vQVDName = PEEK('QVDName', $(i), 'TableName');
LET vFlag = PEEK('Flag', $(i), 'TableName');TRACE vQVDName=$(vQVDName) vFlag=$(vFlag);

topic for loop in App Development

for loop

Re: for loop