topic Re: Percentage calculation in chart in QlikView

Percentage calculation in chart

Thu, 26 Jul 2012 16:39:32 GMT

Hello, consider a column chart with the following:

Series: a, b, c

X-axis: X, Y, Z

|_a b c__a b c__a b c__

X Y Z

Looking at the following points on x-axis:

X: Y:

a = 5 8

b = 2 1

c = 7 3

(total = 14 12)

What I would like is the following values in chart:

X: Y:

a = 5/14=36% 8/12=67%

b = 2/14=14% 1/12=8%

c = 7/14=50% 3/12=25%

|_36 14 50__67 8 25__........

X Y

The numeric values is from count(value), so im not sure what the rest of the division should be.

Something like count(value) / [count(value) for all series on that one point on x-axis]

Thank you!

Re: Percentage calculation in chart

MayilVahanan — Thu, 26 Jul 2012 16:47:26 GMT

Hi,

Try like this,

=Count(Value)/Count(total Value)

Can you post a sample?

Edit:

=Count(Value) / Count(total <X-axis Dimension> Value)

Hope it helps

Re: Percentage calculation in chart

Thu, 26 Jul 2012 16:49:21 GMT

I have already tried that without luck.

Re: Percentage calculation in chart

MayilVahanan — Thu, 26 Jul 2012 16:54:53 GMT

Hi,

Try like this,

=Count(Value) / Count(total <X-axis Dimension> Value)

Can you post a sample?

Hope it helps

Re: Percentage calculation in chart

Thu, 26 Jul 2012 17:12:44 GMT

That worked as a charm! Do you mind explain what <....> does?

Re: Percentage calculation in chart

MayilVahanan — Thu, 26 Jul 2012 17:17:09 GMT

Hi,

It calculate individual total values in dimension..For example:

X total-> 5+2+7 = 14 Y total -> 8+1+3 = 12

a = 5/14=36% 8/12=67%

b = 2/14=14% 1/12=8%

c = 7/14=50% 3/12=25%

Hope you understand the concept.