Percentage Distribution

Fri, 07 Oct 2011 04:27:40 GMT

Hey Guys,

i have an additional problem and hope that some of you can help me.

I need a percentage distribution per gender for some values.

For example:

Our customers could specify her gender and their education level.

User Gender Education Level (Bildung)

1 f MSA

2 f Abitur

3 m MSA

4 m Abitur

5 m MSA

Amount of 5 Users (2 female, 3 male) thereof 3 with education level "MSA" and 2 with "Abitur".

There is no problem to create a chart like this (absolute values of the user):

If i turn on "relative" in the chart properties..

.. the first chart changes in the following way:

QlikView calculates as follows: 1 female with "MSA" divided by all persons (2 females & 3 males) = 20 %

But i need a chart, that calculates as follows: 1 female with "MSA" divided by all females (2 females) = 50 %

This calculation shows the gender intern distribution, and the chart should look like this:

Anyone who has an idea?

(All pictures created with paint)

Many thanks in advance!

Fri, 07 Oct 2011 07:28:19 GMT

Hi,

Please use the below formula to calculate % instead of Relative option.

Count(User)/Count(Total<Gender> User)

SunilChauhan — Fri, 07 Oct 2011 08:21:56 GMT

use expression

Count ( if(Gener='F',User))/ Count (Total<Gender>User)-> in first expression

Count ( if(Gener='M',User))/ Count (Total<Gender>User) in second expression

check relative in both expression

Wed, 12 Oct 2011 11:19:54 GMT

Thank you both! It works! 🙂

topic Percentage Distribution in QlikView