topic Re: How do you create a stacked waterfall chart in QlikView

How do you create a stacked waterfall chart

aetingu12 — Fri, 07 Apr 2017 11:09:17 GMT

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

Re: How do you create a stacked waterfall chart

sunny_talwar — Fri, 07 Apr 2017 15:50:44 GMT

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

Re: How do you create a stacked waterfall chart

aetingu12 — Mon, 10 Apr 2017 09:02:27 GMT

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.

Re: How do you create a stacked waterfall chart

sunny_talwar — Mon, 10 Apr 2017 11:51:59 GMT

Like this?

Re: How do you create a stacked waterfall chart

aetingu12 — Mon, 10 Apr 2017 12:00:09 GMT

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

Re: How do you create a stacked waterfall chart

sunny_talwar — Mon, 10 Apr 2017 15:24:52 GMT

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'),

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 ))

Re: How do you create a stacked waterfall chart

aetingu12 — Mon, 10 Apr 2017 18:41:51 GMT

Thank you very much!!!

Re: How do you create a stacked waterfall chart

Shubham_D — Tue, 26 Nov 2019 07:26:29 GMT

Hi Sunny,

Is it possible in QlikSense ? (Stacked waterfall chart)