Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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/
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
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.