topic stack chart for 2 dimension and 1 exp? in QlikView

stack chart for 2 dimension and 1 exp?

Vidit — Thu, 11 Feb 2016 20:06:35 GMT

i have two dimesnions city and product , and one expression sum of sales.

i want stack bars like:

how to achieve that?

Thu, 11 Feb 2016 20:47:14 GMT

Go to Chart Properties --> Style --> select Stacked

Vidit — Thu, 11 Feb 2016 20:49:34 GMT

those are two dimesnions and only 1 expression. It would have been true for 1 dimension 2 exp

sunny_talwar — Thu, 11 Feb 2016 20:49:37 GMT

Try this:

Vidit — Thu, 11 Feb 2016 20:51:12 GMT

thanks for your reply, but those are two dimensions and only 1 exp. product is a dimension it stors A B values. only sales is the count

Thu, 11 Feb 2016 20:52:29 GMT

Please find below Image

sunny_talwar — Thu, 11 Feb 2016 21:19:19 GMT

Not sure I understand, can you may be share a sample data?

avinashelite — Fri, 12 Feb 2016 05:53:50 GMT

add city and peoduct as the dimenisons and sum(sales) as the expressions...and check the stacked bar chart option in the Presentation tab

Anonymous — Fri, 12 Feb 2016 06:00:53 GMT

like this?

Fri, 12 Feb 2016 06:02:10 GMT

can you please attach a sample qvd with your problem

regards

Nishit

oknotsen — Fri, 12 Feb 2016 07:34:29 GMT

Do you mean a QVW?

Fri, 12 Feb 2016 10:23:08 GMT

yes