topic Re: Help to combine a if/else and loop in script in QlikView

Help to combine a if/else and loop in script

Tue, 18 Nov 2014 10:17:25 GMT

I can´t solve this if/else in script. My aim is to load a transactiontabel diffrent depending month(today())

IF Month(Today())=1 OR Month(Today())=2 then

FOR i = $(vMinYear) TO $(vMaxYear)

Let vStartDatum = Date#($(i) & '-01-01', 'YYYY-MM-DD');

Let vSlutDatum = Date#($(i) & '-12-31', 'YYYY-MM-DD');

Tabel:

Load

From ...

ELSE

FOR i = $(vYearToday) TO $(vMaxYear)

Let vStartDatum = Date#($(i) & '-01-01', 'YYYY-MM-DD');

Let vSlutDatum = Date#($(i) & '-12-31', 'YYYY-MM-DD');

Table:

Load

From ...

It the part For i = ... that doesn´t work with the if-statement.

anbu1984 — Tue, 18 Nov 2014 10:31:43 GMT

Did you verify values of variables $(vMinYear) , $(vMaxYear) and $(vYearToday)?

Tue, 18 Nov 2014 12:11:47 GMT

yes. the work fine. I´d change and use a switch case.

Tue, 18 Nov 2014 12:15:33 GMT

NEXT is missing in IF control statement