topic Re: Problem in Loop in QlikView

Problem in Loop

soha1902 — Wed, 03 Feb 2016 06:57:09 GMT

Can any one tell me what is wrong in following code. it get executed without any error but did not populate any data in Fdate field.

FOR i = vStartdate to vEnddate
Tab:
LOAD
if($(i) = $(vStartdate),$(vStartdate),$(vStartdate) + 1) as Fdate;
NEXT i;

Re: Problem in Loop

marcus_sommer — Wed, 03 Feb 2016 07:00:33 GMT

Try:

FOR i = vStartdate to vEnddate
Tab:
LOAD
if($(i) = $(vStartdate),$(vStartdate),$(vStartdate) + 1) as Fdate Autogenerate 1;
NEXT i;

- Marcus

Re: Problem in Loop

soha1902 — Wed, 03 Feb 2016 07:13:59 GMT

Hi Marcus,

Thanks for your prompt answer

now this will fetched all records but in Fdate showing only 2 records. See screenshot

I want to show all the dates in Fdate field. Plz suggest.

Also can you let me know without autogenerate why it was not reloading any record?

Re: Problem in Loop

tamilarasu — Wed, 03 Feb 2016 07:15:43 GMT

Simply try,

Tab:
Load  
  date($(vStartdate) + RowNo()-1) as TempDate  
AutoGenerate $(vEnddate) - $(vStartdate) + 1;

Re: Problem in Loop

settu_periasamy — Wed, 03 Feb 2016 07:19:40 GMT

that is problem with if($(i) = $(vStartdate) , this will be always true

FOR i = vStartdate to vEnddate

Tab:

Load $(i) as Fdate Autogenerate 1;

NEXT i;

Re: Problem in Loop

tresB — Wed, 03 Feb 2016 07:21:25 GMT

Try :

FOR i = vStartdate to vEnddate

Tab:

LOAD

Date($(i)) as Fdate Autogenerate 1;

NEXT i;