Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Year over Year Comparison with Stacked Bar Chart

I have a table of data with Loaded Miles, Empty Miles, Delivery Date, Delivery Year, Delivery Quarter, and Delivery Month.  The Loaded and Empty Miles make up the stacked bars.  I have a Drilldown created that goes Year > Quarter > Month.  Now, I need to add a year over year comparison.  How do I add the YoY comparison?

3 Replies
Khan_Mohammed
Honored Contributor II

Re: Year over Year Comparison with Stacked Bar Chart

Year-over-Year Comparisons

The above discussion will be helpful for you.

Thanks.

hytown2000
New Contributor III

Re: Year over Year Comparison with Stacked Bar Chart

Create another expression with Set Analysis for last year

Highlighted
sarahplymale
Contributor

Re: Year over Year Comparison with Stacked Bar Chart

The above discussion is really good for understanding how to setup year-over-year measures and data models. It sounds like you want a stacked bar for current year grouped next to a stacked bar for prior year.  I don't think this is possible in QlikSense.  You can't have grouped stacked bars on the same plot only grouped single bars.  If you can come up with a single measure like the ratio of empty to loaded, then you can group by year to look at year-over-year. Something like the below:

2016-11-15_16-21-06.png2016-11-15_16-25-44.png