topic Re: Need help in If statement in the Load Script in QlikView

Need help in If statement in the Load Script

Mon, 03 Sep 2012 09:56:19 GMT

Hello Friends,

In the Load statement, I am trying to list the name of the months using my data but its showing only one month(Sep 2012) as Monthname.

Can anybody tell where I am making a mistake.

If([MONTH 01], Monthname(Today()-1),

If([MONTH 02], Monthname(Today()-2),

If([MONTH 03], Monthname(Today()-3)))) as MonthName

Regards

Chriss

whiteline — Mon, 03 Sep 2012 10:18:28 GMT

Instead subtractacting days Monthname(Today()-1)

You should subtract months: Monthname(Today())-1

Mon, 03 Sep 2012 10:35:49 GMT

Hello Whiteline,

I tried what you said, but date format is coming like (31/08/2012).

Regards

Chriss

whiteline — Mon, 03 Sep 2012 10:58:03 GMT

Sorry, Monthname actualy also returns full date (confused it with month()).

you should try AddMonths(Today(),-1).

Then if you want to change date format just use date() function.

gandalfgray — Mon, 03 Sep 2012 11:02:49 GMT

try the AddMonths function:

If([MONTH 01], Monthname(AddMonths(Today(),1),

If([MONTH 02], Monthname(AddMonths(Today(),2),

If([MONTH 03], AddMonths(Monthname(Today(),-3)))) as MonthName

jonathandienst — Mon, 03 Sep 2012 11:17:13 GMT

Assuming [Month 01] a flag value (ie values 0 or 1 or true() or false()? If so:

If ([MONTH 01], MonthName(AddMonths(Today(), -1)),

If ([MONTH 02], MonthName(AddMonths(Today(), -2))...)).

Regards

Jonathan