topic Re: Previous month in QlikView

Previous month

Nagaraju_KCS — Mon, 15 Jul 2013 13:51:55 GMT

Hi All,

I have jan, feb, mar.......... Dec

If i am click March i want to show Feb Month data..(i want show Preious month) in script level...

Thanks...

kaushiknsolanki — Mon, 15 Jul 2013 13:55:55 GMT

Hi,

Try this code.

Load Month(Date) as Current_Month,

Month(Addmonths(Date,-1)) as Previous _Month

From xyz.

Regards,

Kaushik Solanki

its_anandrjs — Mon, 15 Jul 2013 14:02:09 GMT

Hi,

Another way is use variable like vPrevMonth = Month(Addmonths(DateField,-1))

Thanks

Nagaraju_KCS — Mon, 15 Jul 2013 14:05:09 GMT

ThankU for Response............