topic Stacked Bar Chart - 100% in QlikView

Stacked Bar Chart - 100%

Thu, 25 Mar 2010 12:30:48 GMT

I do not see an option for a 100% Stacked Bar Chart (as is available in PowerPoint). Does anyone have a workaround for this?

Thanks.

Stacked Bar Chart - 100%

Oleg_Troyansky — Thu, 25 Mar 2010 12:34:24 GMT

The workaround is to calculate percentages in your expression. For example:

Dimensions:

Country

City

Expression:

sum(Sales) / sum( TOTAL <Country> Sales)

This way, the sales for each City will be presented as a % from the sales for each Country. At the Country level, the result is always 100%

Stacked Bar Chart - 100%

Thu, 25 Mar 2010 12:45:28 GMT

Hi Oleg,

Thank you very much for your reply. Your suggestion totally works! I really appreciate your time!

Stacked Bar Chart - 100%

Wed, 27 Apr 2011 11:11:40 GMT

Oleg - that does indeed work. But, you knew this was coming, what if I want to have the count of each of the bars in each of the segments that make up each bar - and not the percentage total.

For instance - if I display each country on the x-axis and each bar is split by city. The measure looks at the number of people visiting, how can I display the actual number of people visiting and not using the % of the total for each city/country combo?

Stacked Bar Chart - 100%

Fri, 09 Sep 2011 22:36:14 GMT

This solved the problem I've been working on for the last two hours! Thank you!