topic Re: percentage require from gender count column in QlikView

percentage require from gender count column

yadav_anil782 — Wed, 07 Sep 2016 07:18:55 GMT

Hi team ,

i have one dimension column " gender" and one Count of gender which is calculated column,

in next column i need percentage of male and female so how to calculate the value . plz suggest i attached excel sheet

Re: percentage require from gender count column

ashfaq_haseeb — Wed, 07 Sep 2016 07:44:17 GMT

Hi,

Add 1 more expression to your pivot table.

Assuming your Count Expression is as follows

=Count(Gender)

Add another expression as below (Percentage)

=Count(Gender)/Count(Total Gender)

Now go to Number Tab select expression (Percentage) Change the number format setting to Number select 4 Precision and make sure to select show in % checkbox then click ok.

have a look at attached image.

hope it helps

Regards

ASHFAQ

Re: percentage require from gender count column

yadav_anil782 — Wed, 07 Sep 2016 08:04:33 GMT

Hi ,

gender is dimension field , i need to calculated emp count field

Re: percentage require from gender count column

ashfaq_haseeb — Wed, 07 Sep 2016 08:09:48 GMT

Hi,

Modify script accordingly

=Count(Emp)

Add another expression as below (Percentage)

=Count(Emp)/Count(Total Emp)