topic Re: do while with if statement in QlikView

do while with if statement

wunderch — Thu, 02 Jan 2020 09:32:59 GMT

Hi Guys,

I have a problem with do while and an if statement.

I want to load Data from 5 Years ago to today, but on 01.01. the Data should be load from 5 years ago to year(today)-1, because on 01.01. I haven't Data from the actual year.

Example:

LET a=year(today())-5;

if num(month(Today()))=01 and day(today())=01 then

do while a<=year(today())-1;

ELSE

do while a<=year(today());

TEST:

Load

from TEST_(a).csv;

LET a=a+1;

Loop

ENDIF;

How can I do this????

Regards Chris

Re: do while with if statement

Frank_Hartmann — Thu, 02 Jan 2020 11:25:58 GMT

Maybe like this:

if num(month(Today()))=1 and num(day(today()))=1 then For a = year(today())-5 to year(today())-1; TEST$(a): Load *, FileName() as Filename FROM [Test_$(a).csv]; next a; ELSE For b = year(today())-5 to year(today()) TEST$(b): Load *, FileName() as Filename FROM [Test_$(b).csv]; next b; endif;

Re: do while with if statement

wunderch — Thu, 02 Jan 2020 12:06:10 GMT

Hi Frank,

thanks for your quick answer.

Yes this works!

Have a nice day!

Chris

Re: do while with if statement

Frank_Hartmann — Thu, 02 Jan 2020 12:31:31 GMT

if you want to do it with a do while clause then also try this:

LET a=year(today())-5; if num(month(Today()))=1 and num(day(today()))=1 then do while a<=year(today())-1; TEST: Load *,FileName() as Filename From [C:\Users\admin\Desktop\Neuer Ordner (5)\Test_$(a).xlsx] (ooxml, embedded labels, table is Tabelle1); Let a=$(a)+1; loop; ELSE do while a<=year(today()); TEST: Load *,FileName() as Filename From [C:\Users\admin\Desktop\Neuer Ordner (5)\Test_$(a).xlsx] (ooxml, embedded labels, table is Tabelle1); Let a=$(a)+1; Loop ENDIF;