Solved: Previous month - Qlik Community - 481051

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services| Qlik Help |

Ask a Question

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...

1 Solution

Accepted Solutions

Hi,

Try this code.

Load Month(Date) as Current_Month,

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

From xyz.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

3 Replies

Hi,

Try this code.

Load Month(Date) as Current_Month,

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

From xyz.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Hi,

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

Thanks

Author

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