Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Percentage calculation in chart

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!

1 Solution

Accepted Solutions

Re: Percentage calculation in chart

Hi,

     Try like this,

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

     Can you post a sample?

     Hope it helps

5 Replies

Re: Percentage calculation in chart

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

Not applicable

Re: Percentage calculation in chart

I have already tried that without luck.

Re: Percentage calculation in chart

Hi,

     Try like this,

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

     Can you post a sample?

     Hope it helps

Not applicable

Re: Percentage calculation in chart

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

Re: Percentage calculation in chart

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.

Community Browser