

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Solved
Solved

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not really. With two dimensions you can only use one expression. See attached qvw for the closest I can come to your requirements.
talk is cheap, supply exceeds demand


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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-circum...
hope it helps,
Michael


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
PC


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
??? please, close this post!!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sebastians method worked for me.
