Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shannoypaul
Creator
Creator

Year over Year (YOY) display

YOY1.JPG.jpg

LB.JPG.jpg LB1.jpg

Hi guys,

I need help, I want to display a year over year bar chart.

When we select any year, it should should display a year over year for the selection and for the previous year.

The expression should be based on the number of "Low"  Consumers or on the number of "High" Consumers

Thanks in Advance

1 Solution

Accepted Solutions
Not applicable

Expression 1

Count({< Year={$(=max(Year))}>} Consumers)

Expression 2

Count({< Year={$(=max(Year)-1)}>} Consumers)

View solution in original post

2 Replies
Not applicable

Expression 1

Count({< Year={$(=max(Year))}>} Consumers)

Expression 2

Count({< Year={$(=max(Year)-1)}>} Consumers)

Not applicable

Hi,

add a calculated dimension for year like this

=if(Year=$(=Max(Year)) or Year=$(=Max(Year)-1),Year)

and in expression give

=count(Consumers)