# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean:
Creator III

## Solved

Solved

7 Replies

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
Partner - Creator III

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

Specialist

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!

Not applicable

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)
ToyotaCorolla
Toyota

Camery

BMW1 Series
BMW

4 Series

BMW

5 Series

VWGolf GTI

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

Thank you very much.

PC

Specialist

Not applicable

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

Creator

Sebastians method worked for me.

Community Browser