topic loop in QlikView

loop

yelin_nyu — Fri, 14 Mar 2014 19:45:49 GMT

I was trying to use loop function to lable my files in correct dates.

Ref:

load * INLINE [
    c, Ship_File_Date, Fcst_File_Date
    1, 20130322, 20130118
    2, 20130419, 20130215
    3, 20130524, 20130322
];

for i=1 to 1
let vStart=i;
trace >>>$(vStart);
let vShip=if(c='$(vStart)', Ship_File_Date);
trace >>>$(vShip);
next i;

returns me absolutely nothing. what did i do wrong? thanks

Re: loop

Fri, 14 Mar 2014 19:56:17 GMT

Hi there, can you please elaborate a little bit more on what your requirement is?

Re: loop

its_anandrjs — Fri, 14 Mar 2014 20:02:02 GMT

Hi,

Explain more please what is requirement for loop.

Thanks & Regards

Re: loop

MK_QSL — Fri, 14 Mar 2014 20:05:28 GMT

Ref:

load * INLINE [

c, Ship_File_Date, Fcst_File_Date

1, 20130322, 20130118

2, 20130419, 20130215

3, 20130524, 20130322

];

For i=0 to NoOfRows('Ref')-1

Let vStart =Peek('c',$(i),'Ref');

trace >>> $(vStart);

Let vShip = Peek('Ship_File_Date',$(i),'Ref');

trace >>> $(vShip);

next i;