Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
bo1980
New 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!

 

5 Replies
anushree1
Valued Contributor

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

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

bo1980
New Contributor II

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

I've updated the attached qvw
anushree1
Valued Contributor

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

Please check if the attached works

bo1980
New Contributor II

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

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

anushree1
Valued Contributor

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

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