Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dilipkumard12
New Contributor II

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.

1 Solution

Accepted Solutions
YoussefBelloum
Esteemed Contributor

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:

sub totals.png

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

Expression for % quantity is:

sum(quantity)/sum(TOTAL quantity)

10 Replies
YoussefBelloum
Esteemed Contributor

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

Hi,

Just add another measure: %

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)

dilipkumard12
New Contributor II

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

Thank you for your Reply.

I will works as per your logic.

I want to show in Sub Total.

It will be sown as another column.

YoussefBelloum
Esteemed Contributor

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

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

dilipkumard12
New Contributor II

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

Its fully Expanded

YoussefBelloum
Esteemed Contributor

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 ?

OmarBenSalem
Esteemed Contributor

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

YoussefBelloum
Esteemed Contributor

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

as soon as I see the expected output

dilipkumard12
New Contributor II

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

docview.gif

OmarBenSalem
Esteemed Contributor

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

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

Community Browser