topic Year over Year (YOY) display in QlikView

Year over Year (YOY) display

shannoypaul — Tue, 22 Jul 2014 05:59:33 GMT

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

Tue, 22 Jul 2014 06:05:31 GMT

Expression 1

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

Expression 2

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

Tue, 22 Jul 2014 06:27:06 GMT

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)