topic Stacked Bar Chart in QlikView

Stacked Bar Chart

Wed, 27 Jul 2011 14:58:36 GMT

Hi,

I have a chart as attached below. I would like to have the values shown inside the segments as the individual percentage of total value across each bar.

For Ex : In chart for Bar A, for the first segment i would like to have (34)/(34+11+5+21+1) = 34/72 = .4722 as the value. But the Bar value should be 34 only. I would just want the display value to be changed in terms of the percentage.

Can anyone help me on this.

Thanks

Hariharan

Stacked Bar Chart

Wed, 27 Jul 2011 15:30:32 GMT

Try setting the Relative option in the Expressions tab.

Hope this works!

Sean

Re: Stacked Bar Chart

Wed, 27 Jul 2011 15:38:42 GMT

Hi Haran.

Here is an example.

Hope this help!

Regards.

Stacked Bar Chart

Wed, 27 Jul 2011 15:50:24 GMT

Hi Emmanuel,

Thanks a lot for this. But as i posted in my original request i m looking for a value .4722 in my bar instead of 34.

This value is obtained by (34)/(34+11+5+21+1) calculation. I would like to know if it possible to have the bar created for value 34 and the number on the bar to be shown as 0.4722(34 is .4722 of 72). Please let me know if i m explaining my requirement clearly.

Thanks

Hariharan

Re: Stacked Bar Chart

Wed, 27 Jul 2011 15:55:35 GMT

Hi Haran.

Sure, when i checked again my example i realized that.

I think this is the correct calculation for de Col1 = A

(34)/(34+11+5+2+1+1), 34/54 = .6296

I´m attaching a new example.

Regards.

Stacked Bar Chart

Wed, 27 Jul 2011 16:22:38 GMT

Using the Relative option will treat the total i.e. 72 as 100%, so should display 47.22% in the stacked bar which is the individual percentage of the total. If you specifically need the value displayed as 0.4722 however, then this would not work.

Stacked Bar Chart

Wed, 27 Jul 2011 17:32:30 GMT

Hi Sean and Emmanuel,

Thanks very much for the response. I will try both and will update on the same.

Thanks

Hari