2 Replies Latest reply: Apr 23, 2012 1:21 PM by Dinesh Kumar

Partial sum in Pivot table

Dinesh Kumar Apr 23, 2012 11:31 AM

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.

test1.qvw 138.5 K

Re: Partial sum in Pivot table

Marc Livingston Apr 23, 2012 11:55 AM (in response to Dinesh Kumar)

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

if(dimensionality()<>1, Sum([Selling Price]))
Like Show 0 Likes (0)

Actions
- Partial sum in Pivot table
  
  Dinesh Kumar Apr 23, 2012 1:21 PM (in response to Marc Livingston)
  
  Hi, I found solution using advanced aggregation mentioned in below link.
  http://community.qlik.com/message/189352#189352
  
  Thanks.
  
  Like Show 0 Likes (0)
  
  Actions

Go to original post