topic Re: Waterfall Chart: Showing 3 Expressions with an associated Dimension in QlikView

Solved

microwin88x — Sat, 18 Jan 2014 04:29:39 GMT

Solved

Re: Waterfall Chart: Showing 3 Expressions with an associated Dimension

Gysbert_Wassenaar — Sat, 18 Jan 2014 07:49:47 GMT

Not really. With two dimensions you can only use one expression. See attached qvw for the closest I can come to your requirements.

Re: Waterfall Chart: Showing 3 Expressions with an associated Dimension

agilos_mla — Sat, 18 Jan 2014 09:39:41 GMT

Hi,

You might find how to build the viz you want at : http://qvdesign.wordpress.com/2012/08/24/the-breakdown-bar-chart-a-little-bit-more-in-certain-circumstances-than-youre-average-bar-chart/

hope it helps,

Michael

Re: Waterfall Chart: Showing 3 Expressions with an associated Dimension

sebastiandperei — Sat, 18 Jan 2014 16:10:34 GMT

You should put the expressions in a Dimmention.

1- First Dimmention, a calculated one like: Valuelist('phase 1','phase 2','phase 3')

2- Second Dimmention, the field that are in the different colours in Waterfall2.png

3- One expression:

= Pick ( Match (Valuelist('phase 1','phase 2','phase 3'),'phase 1','phase 2','phase 3'),

sum(ph1), // your phase 1 expression

sum(ph2), // your phase 1 expression

sum(ph3) // your phase 1 expression

)

Try and tell me!

Re: Re: Waterfall Chart: Showing 3 Expressions with an associated Dimension

Mon, 25 Aug 2014 05:28:36 GMT

Hi Gysbert:

Will your method works when the elements in the second dimension for each group of the first dimension are not the same.

Something like:

Make (Dimension 1)	Model (Dimension 2)
Toyota	Corolla
Toyota	Camery
BMW	1 Series
BMW	4 Series
BMW	5 Series
VW	Golf GTI

If that is the case, how would you do the bar off set?

Thank you very much.

Re: Waterfall Chart: Showing 3 Expressions with an associated Dimension

sebastiandperei — Tue, 16 Sep 2014 02:50:40 GMT

??? please, close this post!!!

Re: Waterfall Chart: Showing 3 Expressions with an associated Dimension

Wed, 24 Dec 2014 12:38:48 GMT

Hi,

Is there any option to get Total on Left side instead of right side in the water fall chart that is shown in the above example?(with out Hard coding in the Dimension)

Thankyou

Ramgopal

Re: Waterfall Chart: Showing 3 Expressions with an associated Dimension

erikzions — Wed, 30 Mar 2016 22:17:15 GMT

Sebastians method worked for me.