Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
TMcMahon
Contributor
Contributor

Multi-Series Stacked Column Combo Chart

I am attempting to create a multi-series stacked column chart with a line. 

Multi-Series Stacked Combo Chart.jpg

 

For each MonthYear I want to have a column for Product In and Product Out and each one stacked to show Actual and Forecast.  The line will show the Inventory level.

 

I have been able to create the stacked column chart utilizing 3 dimensions: MonthYear, In/Out, and Actual/Forecast.  I had one expression with nested If-Statements to create a sum for each segment of each column.  The expression also had a nested If-Statement for background color.

Multi-Series Stacked Combo Chart Qlik.JPG

When I add the line for inventory level, the chart breaks. 

Due to the dynamic nature of the application, I can't create two charts and overlap with transparent background.

Any suggestions of how to create this chart would be greatly appreciated.  Thank you. 

0 Replies