Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I compare current years with previous years in a digramm

Hello again,

I have a problem with two years in a digramm. The diagramm should display the month of the current year and the same month of the previous year.

How can I set the properties for the two years in the month.

Thank you.

2 Replies
Not applicable
Author

Hello

One way is to define a variable:

vSameMonthLastYear = month(addmonths(ActualMonth),12)

And then use the variable in your set analysis statement.

Jesper

flipside
Partner - Specialist II
Partner - Specialist II

In your chart, set month as the first dimension and year as your second dimension, you should then be able to see the values grouped by month.

flipside