Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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)