Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Master II
Master II

Year-over-Year Comparisons

The above discussion will be helpful for you.

Thanks.

Highlighted
Contributor III
Contributor III

Create another expression with Set Analysis for last year

Highlighted
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