Solved: Re: 100% Stacked Bar Chart - Qlik Community

nikhilgandhi715 · ‎2015-01-13

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.

morganaaron · ‎2015-01-13

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.

View solution in original post

NickHoff · ‎2015-01-13

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

rubenmarin · ‎2015-01-13

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

morganaaron · ‎2015-01-13

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.

nikhilgandhi715 · ‎2015-01-13

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.

nikhilgandhi715 · ‎2015-01-13

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.

nikhilgandhi715 · ‎2015-01-13

Thanks a lot Aaron, It worked fine.