Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MK9885
Master II
Master II

Year-over-Year Comparisons

The above discussion will be helpful for you.

Thanks.

hytown2000
Partner - Contributor III
Partner - Contributor III

Create another expression with Set Analysis for last year

sarahplymale
Creator
Creator

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