Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
aetingu12
Contributor

How do you create a stacked waterfall chart

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:

Waterfall one.JPG

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:

Waterfall two.JPG

Expression_Stack.JPG

Any help on this is much appreciated.

Regards,

Aksel

Tags (2)
1 Solution

Accepted Solutions

Re: How do you create a stacked waterfall chart

6 Replies

Re: How do you create a stacked waterfall chart

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

aetingu12
Contributor

Re: How do you create a stacked waterfall chart

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

aetingu12
Contributor

Re: How do you create a stacked waterfall chart

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

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
Contributor

Re: How do you create a stacked waterfall chart

Thank you very much!!!