Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

akuttler
Contributor

Display Field in Pivot Table as a % of Total

Hi I have a pivot table to display the AR balances for Insurance Payers.

Row field is Insurance Name

Measure Column  is Total AR = Sum([Total IB)]

Table display :

INSURANCE NAME:          TOTAL AR:

BCBS                                   32K

CIGNA                                  50K

MEDICARE                         100K

I am simply trying to show the Total AR  as a % of Total

I tried Sum([Total IB])/Sum({1}[Total IB])

But it displays 100% for all the Payers.

Thanks in advance.

1 Solution

Accepted Solutions

Re: Display Field in Pivot Table as a % of Total

Try TOTAL instead of {1}

Sum([Total IB])/Sum(TOTAL [Total IB])

{1} is used for ignoring selections

TOTAL is used for show total of your expression across all rows

2 Replies

Re: Display Field in Pivot Table as a % of Total

Try TOTAL instead of {1}

Sum([Total IB])/Sum(TOTAL [Total IB])

{1} is used for ignoring selections

TOTAL is used for show total of your expression across all rows

akuttler
Contributor

Re: Display Field in Pivot Table as a % of Total

Thank so much, it works.

Community Browser