Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
montubhardwaj
Specialist
Specialist

Partial sum in Pivot table

Hi All,
I have a Pivot table with two expressions and multiple Dimensions. I am doing summation (partial sum) on Item desc and it is working fine. But the partial sum is being shown for both the expression columns. I just want the partial sum for one column alone i.e. partial sum should be shown only for Sum([Unit Price]) alone.
Is this doable in QlikView? Do share your views.

PFA the sample qvw file.

1 Solution

Accepted Solutions
montubhardwaj
Specialist
Specialist
Author

Hi, I found solution using advanced aggregation mentioned in below link.

http://community.qlik.com/message/189352#189352

Thanks.

View solution in original post

2 Replies
Not applicable

For the second expression use if statement and dimensionality() to tell it not to total.

if(dimensionality()<>1, Sum([Selling Price]))

montubhardwaj
Specialist
Specialist
Author

Hi, I found solution using advanced aggregation mentioned in below link.

http://community.qlik.com/message/189352#189352

Thanks.