# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

## Qlik Sense Pivot table - Calculating percentages

Hi,

I am trying to convert Values in a Pivot table into Percentages.

The expression used to get the counts / values is:

>     Count(distinct ID)

I tried using the below formula to get the percentages, but the effort is in vain.

>    Count(distinct ID) / Count( total distinct ID)

>    Count(distinct ID) / Count({\$<Date1>}  total distinct ID))

>    Count(distinct ID) / Count({\$<Date2>}  total distinct ID))

>    Count(distinct ID) / Count({\$<Date1>}  distinct ID))

>    Count(distinct ID) / Count({\$<Date1>} distinct ID))

The sample data appears like this:

Table 1:

 Date2 Date1 2016May 2016Jun 2016Jul 2016Aug Totals 1570 200 330 560 380 2016May 560 200 150 90 120 2016Jun 430 - 180 220 30 2016Jul 330 - - 250 80 2016Aug 250 - - - 150

Table 2: Required

 Date2 Date1 2016May 2016Jun 2016Jul 2016Aug Totals 1570 2016May 560 36% 27% 16% 21% 2016Jun 430 - 42% 51% 7% 2016Jul 330 - - 76% 24% 2016Aug 250 - - - 60%

Kindly suggest the appropriate method to get the results.

Regards,

Mrutyunjaya

Tags (3)
4 Replies

## Re: Qlik Sense Pivot table - Calculating percentages

Try Count(distinct ID) / Count(TOTAL <Date1> distinct ID)

talk is cheap, supply exceeds demand
New Contributor II

## Re: Qlik Sense Pivot table - Calculating percentages

Hi Gysbert,

The objective is not met here again. The formula divides each value by Total(row totals).

viz; 560 / 1570

200 / 1570

150 / 1570

But, the desired value is,

viz;  560 / 560

200 / 560

150 / 560

Reg,

Mrutyunjaya

Contributor

## Re: Qlik Sense Pivot table - Calculating percentages

How about removing the show total under dimension options and using the same formula

New Contributor II

## Re: Qlik Sense Pivot table - Calculating percentages

No changes. The result is same.