topic Working with stacked bars in QlikView

Working with stacked bars

Anonymous — Mon, 12 Oct 2015 09:30:49 GMT

Hi All,

I am new to Qlikview and I wanted to create a stack bar with my X axis values from one column A. The values of each stack of the bar are represented by different columns namely X,Y and Z. Please help me add data to this chart. Please have a look at the diagram for better understanding.

Re: Working with stacked bars

oknotsen — Mon, 12 Oct 2015 09:53:21 GMT

Hi,

In the properties of the chart, go to the "Style" tab and switch from "grouped" to "stacked".

Re: Working with stacked bars

gautik92 — Mon, 12 Oct 2015 09:54:56 GMT

create a bar chart write expressions lik

sum(X)

sum(Y)

sum(Z)

and go to style tab and give stacked

Re: Working with stacked bars

Anonymous — Mon, 12 Oct 2015 09:58:24 GMT

The stacked option is Disabled. I am not able to select this

Re: Working with stacked bars

oknotsen — Mon, 12 Oct 2015 10:00:21 GMT

This means you probably have only 1 expression.

Add the expressions that result in the other values. After that you can use the Stacked option.

Re: Working with stacked bars

ogster1974 — Mon, 12 Oct 2015 10:01:54 GMT

Setting your chart to stacked in style properties will do the trick.

Re: Working with stacked bars

avinashelite — Mon, 12 Oct 2015 10:02:29 GMT

if you have x,y and Z in a column .i.e all in one column you can directly add it as dimension

Re: Working with stacked bars

gautik92 — Mon, 12 Oct 2015 10:03:50 GMT

you should have atleast two expressions for that please check that you have 2 expr

Re: Working with stacked bars

Anonymous — Mon, 12 Oct 2015 10:03:59 GMT

I have added one dimension and 3 expressions as sun(x),sum(y) and sum(z). The stacked option is still disabled.

Re: Working with stacked bars

oknotsen — Mon, 12 Oct 2015 10:10:20 GMT

Are you sure you selected "Bar chart" on the general tab?

What version and service release of QlikView are you using?

Can you please attach a copy of the document?

Re: Working with stacked bars

gautik92 — Mon, 12 Oct 2015 10:13:06 GMT

you r using bar chart or line chart?

Re: Working with stacked bars

Anonymous — Mon, 12 Oct 2015 10:15:23 GMT

Please share your application for more details.

Re: Working with stacked bars

Anonymous — Mon, 12 Oct 2015 10:21:13 GMT

It worked. Thank you all so much. Can I have the numbers represented on each stack to say how much it each color represents? Please let me know.

Re: Working with stacked bars

nizamsha — Mon, 12 Oct 2015 10:40:31 GMT

For ur information in bar chart,if you want to show stacked bar you have to fulfill this criteria and they are

1) two dimension and one measure

2) one Dimension and two measure

3) one dimension and more measure if u have requirement like that

as my understanding is correct you have one dimension and one measure in that measure u have 3 rows if its like that mean then split that measure in to 3 expression

1) sum(A)

2)sum(B)

3)sum(C)

then go the Style tab changed into Stacked instead of Group Orientation

Re: Working with stacked bars

gautik92 — Mon, 12 Oct 2015 10:51:08 GMT

check value on data points on expression tab and go to presentation tab check on the values inside segment option