topic Re: Stacked bar chart with two dimension and two expression in QlikView

Stacked bar chart with two dimension and two expression

Mon, 23 Nov 2015 23:32:15 GMT

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?

Re: Stacked bar chart with two dimension and two expression

vikasmahajan — Tue, 24 Nov 2015 04:27:20 GMT

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

HTH

Vikas

Re: Stacked bar chart with two dimension and two expression

HirisH_V7 — Tue, 24 Nov 2015 05:12:11 GMT

Hi ,

I hope you requirement is like this,

1) 2 Dimensions

2) 3 Expressions

PFA,

Hope this Helps,

Regards,

HirisH

Re: Stacked bar chart with two dimension and two expression

Tue, 24 Nov 2015 07:10:07 GMT

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.

Re: Stacked bar chart with two dimension and two expression

Wed, 25 Nov 2015 16:35:21 GMT

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!