[HELP] how to make a bar chart like this one ?

[#1]

hello..

i have a problem with a bar chart as a client requested..

we wanna see movement per product.

we use no dimension, we are only playing with expression with sum and if function..

and the bar chart that client wanna is like the picture below :

- the "start position" is the sum of every product total sales

- "corporate" , "commercial" , "micro" , "computer finance" , "treasury" , "institutional" is the sum of every part of total product sale and represent with its own color

- "Final Position" is the part+start position;

example : corporate is with green;. "green color in start" + "green color above corporate" = "green color in final position"

i've tried to make it and the result is like the picture below :

mw question is :

is QlikView able to make a barchart as the first picture present?

if QV is able to do that, then how?

please let me know..

many thx..

sorry for my bad explanation..

regards...

[nathanfurby]

Any good?

[#3]

hello all..

thx for helping..

seems QV unable to do that, so i tricked it with make it to 3 chart

and the result is ok enough

btw many thx for helpin

🙂