Solved: Previous Month Calculation - Qlik Community

gayathridevi24 · ‎2019-01-11

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

anushree1 · ‎2019-01-11

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

View solution in original post

anushree1 · ‎2019-01-11

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

gayathridevi24 · ‎2019-01-11

I have got the answer. Thank you so much Anushree