Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bo1980
Contributor II
Contributor II

Only one Total required in Pivot Table Expression with multiple Dimensions using Partial Sum

I have Pivot Table with 3 Dimensions and 2 Expressions - a number and a percentage. I'm using Partial Sum to get the Total at the bottom (in green), but I only want the number total. How can I remove / hide the percentage total?

partialsum.PNG

Thanks for any help!

 

Labels (3)
5 Replies
anushree1
Specialist II
Specialist II

The attached file is having security constraint as it has section access could you please share a version without section access

bo1980
Contributor II
Contributor II
Author

I've updated the attached qvw
anushree1
Specialist II
Specialist II

Please check if the attached works

bo1980
Contributor II
Contributor II
Author

Although its got rid of the data, I want the row to be removed completely for %

anushree1
Specialist II
Specialist II

Partial sums are grouped at the Dimension Level so a place holder will get created for each expression.

So I dont think it could be removed