topic Re: Loop through table in QlikView

Loop through table

brindlogcool — Sun, 24 Jun 2012 19:58:48 GMT

Hi,

I am trying to loop through the table

For i=1 to NoOfRows('TREE1')

Load

FieldValue('PATH',0) as C1,

RowNo() as Rno

Resident TREE1 WHERE RowNo()=$(i);

Next i

But i am getting zero lines fetched .

swuehl — Sun, 24 Jun 2012 23:28:10 GMT

Try using Recno()=$(i) in your where clause. And I think FieldValue() indexing starts with 1, please recheck.

Regards,

Stefan

brindlogcool — Mon, 25 Jun 2012 18:49:28 GMT

Thanks Stefan, its working now. You are right after using 1 as the index value . it is working fine now.