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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
lrenwick
Contributor III
Contributor III

Convert a Bar and Line Master Chart to a Stacked Bar Chart

Hi,

I have this bar and line chart I want to convert to a stacked bar chart so the segments are coloured based on Rank removing the need for the line chart. 

clipboard_image_0.png

From help articles and looking at other charts I was expecting an option under Presentation to convert the chart into stacked but I don't see this option. The chart is a Master Item - not sure if this has an impact.

clipboard_image_1.png

The current expression for the height of bar is:

Sum({$<$(vDateSelectorMonthlyRolling),SalesOrSupport={Sales}, WeeklyOrMonthly={M},[Budget Version]=>} [Leaver])

Is there a way to edit this to segment by rank?

Thanks in advance for any help! 

 

 

Labels (1)
3 Replies
Lisa_P
Employee
Employee

At the moment your chart is a combo chart. Convert it to a bar chart and you can stack it.
lrenwick
Contributor III
Contributor III
Author

Thanks, how do I convert into a bar chart? 

 

Sorry total newbie to Qlik and don't see the option! 

Lisa_P
Employee
Employee

Drag it on top of the chart from the assets panel in the charts section and select convert to