topic Re: Showing percentages in stack bar chart for each stack that is relative to that total bar in QlikView

Showing percentages in stack bar chart for each stack that is relative to that total bar

Anonymous — Mon, 28 Jul 2014 15:58:47 GMT

Hi All,

I'm facing an issue with the Stack bar chart where I want to show the % for each stack that is relative to the entire bar. I mean if I've 4 stacks in one bar, then I want to show 25% in each stack.

Thanks in advance for your help!!!

Re: Showing percentages in stack bar chart for each stack that is relative to that total bar

Mon, 28 Jul 2014 16:01:26 GMT

I believe, Use the Total Qualifier in the expression

Sum(Sales) / Sum(TOTAL <DIM1> Sales)

Re: Showing percentages in stack bar chart for each stack that is relative to that total bar

Mon, 28 Jul 2014 16:01:44 GMT

If not working please post sample qvw.

Re: Showing percentages in stack bar chart for each stack that is relative to that total bar

Anonymous — Mon, 28 Jul 2014 16:48:39 GMT

Hey Thanks,

Actually after posting the question, I figured out the answer by looking at this post Re: showing values in % but after this bar has changed to 100% stacked bar chart. Is it something can we avoid, I mean we can use the stack bar chart as per the real values but when showing the values in the stacks, then it should show the %.

Thanks!!!

Re: Re: Showing percentages in stack bar chart for each stack that is relative to that total bar

JonnyPoole — Mon, 28 Jul 2014 18:08:17 GMT

Does the attach help ?

Re: Showing percentages in stack bar chart for each stack that is relative to that total bar

Fri, 09 Jan 2015 08:51:29 GMT

Can you attach the qvw?

Re: Showing percentages in stack bar chart for each stack that is relative to that total bar

rubenmarin — Fri, 09 Jan 2015 09:25:58 GMT

Hi, you can use Dual function to split the value that defines the high of the bar, and the value shown:

Dual(Sum(Sales), Num(Sum(Sales) / Sum(TOTAL <DIM1> Sales), '#.##0,00%')

Probably you need to set 'Predefined Expression' in Numbers tab

Re: Showing percentages in stack bar chart for each stack that is relative to that total bar

Wed, 21 Oct 2015 14:57:11 GMT

Hi Ruben !

How if i have many dimensions ? By what can i replace DIM1 in your exemple in ordrer to make it bynamic ?

Thank you for your response

Am'

Re: Showing percentages in stack bar chart for each stack that is relative to that total bar

rubenmarin — Thu, 22 Oct 2015 09:14:00 GMT

You can replace DIM1 by your chart expressions, ie:

<DIM1, DIM2...>

To make it dynamic you can create a variable that returns the dimensions string and use this variable, ie:

variable vDimensions = =If(GetSelected... or =Concat(DimensionSelector, ', ')

// something that returns you the string with dimensions, depens on your model and how works your dynamic chart.

Then use the variable:

Dual(Sum(Sales), Num(Sum(Sales) / Sum(TOTAL <$(vDimensions)> Sales), '#.##0,00%')

Re: Showing percentages in stack bar chart for each stack that is relative to that total bar

Thu, 22 Oct 2015 16:14:40 GMT

Thank you !!