topic Re: stacked waterfall graph in QlikView

stacked waterfall graph

Vidit — Wed, 25 Nov 2020 16:16:04 GMT

i have the following stacked graph, with two dimension and an expression

how can i convert it to waterfall graph. PFA the qvw.

thanks

Quarter	Region	SALE
Q1	E	10
Q1	W	20
Q1	N	80
Q1	S	10
Q2	E	25
Q2	W	15
Q2	N	20
Q2	S	25
Q3	E	32
Q3	W	10
Q3	N	5
Q3	S	50

Re: stacked waterfall graph

sunny_talwar — Mon, 04 Apr 2016 20:13:30 GMT

Like this?

Bar Offset Expression:

=If(Region = 'E',

If(Quarter = 'Q2',Sum(TOTAL {<Quarter = {'Q1'}>}Sale),

If(Quarter = 'Q3',Sum(TOTAL {<Quarter = {'Q1', 'Q2'}>}Sale))))

Re: stacked waterfall graph

Vidit — Wed, 06 Apr 2016 19:07:17 GMT

Hi,

Thanks for your message.\

But i would not like to hardcode the quarter vaules, i was hoping to do this using rangesum. is that possible?

Re: stacked waterfall graph

sunny_talwar — Wed, 06 Apr 2016 19:11:09 GMT

Try this:

=Aggr(RangeSum(Above(Sum(Sale), 1, RowNo())), Quarter)

Re: stacked waterfall graph

Tue, 07 Feb 2017 15:44:52 GMT

Hi Sunny,

i try to use your algorithm on my data to realize exactly what you solve. But there are some cases that it fail. I create a chart in wich the 2 dimension can vary dinamically (so i've a source table with more than 2 dimensions). But in some case i have stacked that collapse to zero. If you take a look to my .qvw you understand my problem. I think the problem is the order in wich i load the data, so if the data is ordered by the second dimension the problem disappear, but due to the dinamically change of dimensions i'can't have data order by a static dimension ... Can you help me?

Thx a lot !

Re: stacked waterfall graph

sunny_talwar — Tue, 07 Feb 2017 16:41:27 GMT

I might not have understood your issue completely, but try the attached

Just worked on this one chart. Not sure if you were referring to the charts at the bottom or this. But let us know

Re: stacked waterfall graph

Mon, 13 Feb 2017 15:33:27 GMT

Hi sunny, your tip is exactly what i want. But there are some cases that still doesen't work (see image 1).

I thought I had solved unchecking on "Suppress zero values" (See image 2)

But this uncheck in some cases cause this error: "Drawing of chart failed internally" (see image 3)

While if i check "Suppress zero values" the error disappear and the chart appears correctly... (see image 4)

See the attachment for QVW

Re: stacked waterfall graph

sunny_talwar — Mon, 13 Feb 2017 16:03:23 GMT

I am not seeing the issue as you mentioned (Drawing of chart failed internally)

Re: stacked waterfall graph

Mon, 13 Feb 2017 16:09:26 GMT

Probably is due to the version of qlikview? Wich version do you use? I have 11.20.12904.0 SR12 64bit edition . The strange thing is that another my collegue wich has 11.20 sr15 can see this association (Dimensione->Priorita, Dettaglio->Ambito di competenza) but has the error message in another association... it seems random? Please try to visualize all possible combination in Dimensione and Dettaglio... see if there is some case that fail... thx!!!

Re: stacked waterfall graph

sunny_talwar — Mon, 13 Feb 2017 16:16:54 GMT

I have QV 12 (Version 12.10.10000.0 SR1)... checking

Re: stacked waterfall graph

sunny_talwar — Mon, 13 Feb 2017 16:18:57 GMT

All combinations are working for me

Re: stacked waterfall graph

Thu, 16 Feb 2017 10:44:08 GMT

Thank you Sunny for your support, your work is great! For the other problem i create a new post 🙂