How do you create a stacked waterfall chart

[aetingu12]

Dear all,

I am trying to create a waterfall chart that is stacked.  I am able to create a waterfall chart like the one below by creating multiple expressions and offsetting one from the previous ones:

However I would like to have each segment as stacked by product as below.  I managed this with moving all to dimensions and with one expression.  This does give the desired stack, but since I have one expression, how do I offset each output within the expression:

Any help on this is much appreciated.

Regards,

Aksel

[sunny_talwar]

Would you be able to share a sample to look at this?

[aetingu12]

Good morning,

Apologies for the delayed reply.  I work on Company Servers so I needed to create a mock view.  Please find attached.  The chart does what I want, but need to have it offset correctly.

[sunny_talwar · Accepted solution]

Like this?

[aetingu12]

Exactly what I was looking for! Thank you.  Could you share the code as a text file?  My system restrictions don't allow me to open files for some reason?

Regards,

Aksel

[sunny_talwar]

I used the following bar offset expression

=pick(Match(ValueList('Opening Balance','No Change','Increase','Decrease','Closing Balance'),'Opening Balance','No Change','Increase','Decrease','Closing Balance'),

0,

0,

sum(TOTAL {<[Summary Date] = {"$(=monthend(addmonths(GetFieldSelections([Summary Date]),-1)))"} >} Balance),

sum(TOTAL {<[Summary Date] = {"$(=monthend(addmonths(GetFieldSelections([Summary Date]),-1)))"} >} Balance)+

sum(TOTAL {<[Summary Date] = {"$(=GetFieldSelections([Summary Date]))"},[Event] = {'Increase'} >} MoM )

+sum(TOTAL {<[Summary Date] = {"$(=GetFieldSelections([Summary Date]))"},[Event] = {'Decrease'} >} MoM ))

[aetingu12]

Thank you very much!!!

[Shubham_D]

Hi Sunny,

Is it possible in QlikSense ? (Stacked waterfall chart)