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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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