topic Re: 100% Stacked Bar Chart in QlikView

100% Stacked Bar Chart

nikhilgandhi715 — Tue, 13 Jan 2015 15:03:49 GMT

Hi All,

I have to create a 100% stacked bar chart with 4 expressions and 1 dimension. How can i achieve it?

Any help would be much appreciated.

Thanks in advance.

Nikhil.

Re: 100% Stacked Bar Chart

NickHoff — Tue, 13 Jan 2015 15:11:57 GMT

In the style tab, select the sub-type of "Stacked".

Re: 100% Stacked Bar Chart

rubenmarin — Tue, 13 Jan 2015 15:16:10 GMT

Hi Nikhil, please check attached document, it may help you to get your requirements.

Instead of ValueList you can load metric description from data_island

Re: 100% Stacked Bar Chart

morganaaron — Tue, 13 Jan 2015 15:16:17 GMT

4 expressions would be Sum(1)/Sum(1+2+3+4), Sum(2)/Sum(1+2+3+4) etc, then set the style option to stacked, ensuring you've only got your one dimension in the dimension list. As long as it all relates to each other, should work okay, then set the formatting in your number tab to show in percent.

Re: 100% Stacked Bar Chart

nikhilgandhi715 — Tue, 13 Jan 2015 15:17:33 GMT

Thanks Nick,

I have selected the style sub-type as "Stacked" however it is not showing as 100%. The bars should show the total value as 100% for multiple expressions on one dimension.

Re: 100% Stacked Bar Chart

nikhilgandhi715 — Tue, 13 Jan 2015 15:39:58 GMT

Hi Ruben,

Thanks for the help, however it is working if i prepare the chart for "Jan'14" but does not work when i am using the same for the entire year.

Re: 100% Stacked Bar Chart

nikhilgandhi715 — Tue, 13 Jan 2015 15:46:55 GMT

Thanks a lot Aaron, It worked fine.