Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakachar21
Contributor II
Contributor II

Stack bar within a water fall chart need someone assistance here.

deepakachar21_0-1708583897972.png

This is a view and now again need to break each stack into multiple items using dimension. But in Qlik Sense I don't have an option to introduce a dimension. I can't even use Ask4 Waterfall extension. 

 

Labels (2)
3 Replies
pravinboniface
Creator II
Creator II

I think you have to resort to the old way of building Waterfall charts before Qlik introduced the waterfall chart object.  You create a stacked barchart but use colors to hide certain stacked bars to give the illusion of a waterfall.  If you go this route, consider the maintenance difficulty for the next person.

I believe this is how we built in the past
https://www.naturalsynergies.com/q-tip-10-waterfall-chart-in-qlik-sense/

 

 

deepakachar21
Contributor II
Contributor II
Author

In the PL code, I cannot make the values stable.

PL:
LOAD * INLINE [
Stage, Amount, Multiplier, Offset
Revenue, 100000, 1, 0,
Labor, 20000, -1, 1
Material, 15000, -1, 1
Overhead, 10000, -1, 1
Profit, 55000, 1, 0
]; 

And FYI, I just want to break the waterfall each bar into multiple stacks using certain dimension. But current Qliksense don't provide an option to introduce a dimension at all instead it asks only measures. Extensions are the option for me to go with now? Whats your thought on this

pravinboniface
Creator II
Creator II

If you can use an extension, I would recommend it.  You cannot specify dimensions in a waterfall chart.  If you want to use dimensions, you have to build your own waterfall chart using a barchart.