Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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 (2)
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