Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

Pivot table percentage calculation help

Hi Experts,

Can any one please help me on below requirement.

In the below table

Dimension is Division

Measure is Count(distinct ID)

Please help me to calculate the percentage like expected output column.

I have tried like Count(distinct ID)/Count(Total distinct ID) but getting wrong percentage.

Please help me on this.


Thanks in advance

1 Solution

Accepted Solutions
agigliotti
Honored Contributor II

Re: Pivot table percentage calculation help

do you have Division value as null ?

if Yes you can use this expression:

Count( DISTINCT ID ) / Count( {< Division = {"*"} >} TOTAL DISTINCT ID )

2 Replies
agigliotti
Honored Contributor II

Re: Pivot table percentage calculation help

what you tried seems to be right.

let's try adding Count( TOTAL DISTINCT ID ) as a new measure column to see what you get.

agigliotti
Honored Contributor II

Re: Pivot table percentage calculation help

do you have Division value as null ?

if Yes you can use this expression:

Count( DISTINCT ID ) / Count( {< Division = {"*"} >} TOTAL DISTINCT ID )

Community Browser