Stacked bar chart with two dimension and two expression

[#1]

Hi everyone!

I would like to create a bar chart showing:

1) sales 2015 (ytd)

2) sales 2014 (ytd)

3) sales 2014 (total)

with Month as dimension.

Moreover, sales 2014 ytd and total should be combined in a stacked bar.

I expect that expression 3 (sales 2014 total) will show only the values after ytd; eg. If today is 23/11/15, exp 3 (sales 2014 total) will show only the values which are not considered by exp 2 (sales 2014 ytd), which means all the sales occurred after 23/11/14.

Which is the best way to do?

Two dimensions bar chart? Month and Year?

How would be the expressions?

[vikasmahajan]

I am not sure but check with this https://community.qlik.com/message/792685#792685

HTH

Vikas

[HirisH_V7]

Hi ,

I hope you requirement is like this,

1) 2 Dimensions

2) 3 Expressions

PFA,

Hope this Helps,

Regards,

HirisH

[#4]

Thanks Vikas and Hirish!

Here it is a picture to explain better my requirements.

Blue bar is current year sales YTD, gray bar is past year sales YTD, and yellow is total sales of past year.

[#5]

I finally made it! But still have a visualization problem!

When there is a selection which excludes at least one value of the dimension, the width of the bar chart reduces automatically and the value are near to overlap.

E.g. when I select a customer which did not bought anything in August, all the bar chart shrink as in the picture.

How can I avoid this?

Thanks in advance!

T.