topic for each in Field in QlikView

for each in Field

Thu, 21 Jan 2010 11:38:04 GMT

Hi!

Is there a way iterating throug the records of a Field?

Like this:

LoadYears:
LOAD * INLINE [
LoadYear
2010
2005
2004
2003
2002
1998];

for each vYear in LoadYear

..do somethis with vYear;

next vYear

for each in Field

Thu, 21 Jan 2010 11:44:59 GMT

I've used something like this successfully in the past:

Let noOfRows = NoOfRows('LoadYears');
for row= 1 to $(noOfRows)
let vYear=fieldvalue('LoadYear', $(row));
..do something with vYear;
next

Hope it helps

/Fredrik