Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

leomathew
New Contributor III

stack chart for 2 dimension and 1 exp?

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

i want stack bars like:

Product A

Product B

Product C

city

how to achieve that?

11 Replies
Not applicable

Re: stack chart for 2 dimension and 1 exp?

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

leomathew
New Contributor III

Re: stack chart for 2 dimension and 1 exp?

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

Re: stack chart for 2 dimension and 1 exp?

Try this:

Capture.PNG

leomathew
New Contributor III

Re: stack chart for 2 dimension and 1 exp?

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

Not applicable

Re: stack chart for 2 dimension and 1 exp?

Please find below Image

BarchartStyle.JPG

Re: stack chart for 2 dimension and 1 exp?

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

Re: stack chart for 2 dimension and 1 exp?

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

balrajahlawat
Esteemed Contributor

Re: stack chart for 2 dimension and 1 exp?

like this?

Not applicable

Re: stack chart for 2 dimension and 1 exp?

hi

can you please attach  a sample qvd with your problem

regards

Nishit

Community Browser