Previous Month Calculation

[gayathridevi24]

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 · Accepted solution]

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]

I have got the answer. Thank you so much Anushree