10 Replies Latest reply: Mar 28, 2018 12:34 PM by youssef belloum

# How to add sub total percentage in Qlik Sense Pivot Table

Can any one suggest how to add Percentage in Sub Total Percentage in Qlik sense Pivot Table.

• ###### Re: How to Sub Total Percentage in Qlik Sense Pivot Table

Hi,

and try this expression:

function(field)/function(total field)

where function: is the function you want to use, example (sum, count...) and field: is your Measure field

for example:

Sum(Turnover)/Sum(total Turnover)

• ###### Re: How to add sub total percentage in Qlik Sense Pivot Table

I will works as per your logic.

I want to show in Sub Total.

It will be sown as another column.

• ###### Re: How to add sub total percentage in Qlik Sense Pivot Table

sub total is displayed when your dimension is not expanded, right ?

• ###### Re: How to add sub total percentage in Qlik Sense Pivot Table

Its fully Expanded

• ###### Re: How to add sub total percentage in Qlik Sense Pivot Table

can you take a screen shot of your pivot table expanded and attach it here please ?

• ###### Re: How to add sub total percentage in Qlik Sense Pivot Table

Maybe he's refering to sthing like this:

sum(Measure) / sum( total <Dim> Measure)

I'll let you handle this youssefbelloum

• ###### Re: How to add sub total percentage in Qlik Sense Pivot Table

as soon as I see the expected output

• ###### Re: How to add sub total percentage in Qlik Sense Pivot Table

sum(total <UrRegionDim> YourMeasure) / sum(total YourMeasure)

• ###### Re: How to add sub total percentage in Qlik Sense Pivot Table

I think the best you can do (without extension and without modifying the script) is this:

I created only some values to test (2 dimensions with only quantity)

Expression for % quantity is:

sum(quantity)/sum(TOTAL quantity)