Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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.