topic Re: Previous Month Calculation in Water Cooler

Previous Month Calculation

gayathridevi24 — Fri, 11 Jan 2019 07:54:57 GMT

Hi All,

I am new to Qlikview. I have tried to solve the expression for the previous month. I am not getting results for the previous month calculation.

Could anyone help to solve this issue. Please find the attached qvw file.

Thanks and regards,

Gayathri Devi

Re: Previous Month Calculation

anushree1 — Fri, 11 Jan 2019 08:22:07 GMT

Hi Gayathri,

The variable vpreviousyear is holding the value 11 and the month field holds the values like jan, feb, mar... and you are passing month=11 in set analysis so qlikview searchesfor 11 in the list containing values like jan, feb etc.

So create a month number field which holds the month numbers and use the field in Set analysis

Re: Previous Month Calculation

gayathridevi24 — Fri, 11 Jan 2019 08:55:35 GMT

I have got the answer. Thank you so much Anushree