Qlik Community

Community Corner

Discussion board for questions on how to use Qlik Community and its features.

Announcements
This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
Highlighted
gayathridevi24
Not applicable

Previous Month Calculation

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

1 Solution

Accepted Solutions
anushree1
Not applicable

Re: Previous Month Calculation

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

2 Replies
anushree1
Not applicable

Re: Previous Month Calculation

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
Not applicable

Re: Previous Month Calculation

I have got the answer. Thank you so much Anushree

Community Browser