Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
dilipkumard12
Creator
Creator

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
Champion
Champion

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)

View solution in original post

10 Replies
YoussefBelloum
Champion
Champion

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
Creator
Creator
Author

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
Champion
Champion

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

dilipkumard12
Creator
Creator
Author

Its fully Expanded

YoussefBelloum
Champion
Champion

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

OmarBenSalem
Partner
Partner

Maybe he's refering to sthing like this:

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

I'll let you handle this youssefbelloum

YoussefBelloum
Champion
Champion

as soon as I see the expected output

dilipkumard12
Creator
Creator
Author

docview.gif

OmarBenSalem
Partner
Partner

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