Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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