Discussion Board for collaboration related to QlikView App Development.
Not really. With two dimensions you can only use one expression. See attached qvw for the closest I can come to your requirements.
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-circum...
hope it helps,
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!
Will your method works when the elements in the second dimension for each group of the first dimension are not the same.
|Make (Dimension 1)||Model (Dimension 2)|
If that is the case, how would you do the bar off set?
Thank you very much.
??? please, close this post!!!
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)
Sebastians method worked for me.