Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mrutyunjaya
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
Date12016May2016Jun2016Jul2016Aug
Totals1570200330560380
2016May56020015090120
2016Jun430-18022030
2016Jul330--25080
2016Aug250---150

Table 2: Required

Date2
Date12016May2016Jun2016Jul2016Aug
Totals1570
2016May56036%27%16%21%
2016Jun430-42%51%7%
2016Jul330--76%24%
2016Aug250---60%

Kindly suggest the appropriate method to get the results.

Regards,

Mrutyunjaya

4 Replies

Re: Qlik Sense Pivot table - Calculating percentages

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


talk is cheap, supply exceeds demand
mrutyunjaya
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

sadasiva
Contributor

Re: Qlik Sense Pivot table - Calculating percentages

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

mrutyunjaya
New Contributor II

Re: Qlik Sense Pivot table - Calculating percentages

No changes. The result is same.

Community Browser