Partial Sums in Pivot Tables

Anonymous — Wed, 15 May 2013 08:21:56 GMT

I have a simple Pivot Table chart that has the Fund and Date as dimension. I have an expression that is based simple x(k,i)/N(k).... where x(k,i) is some value for the the Fund k and date i. And N(k) is some value for Fund k. The number is a %.

Currently the Partial sum is simply a Summation of x(k,i)/N(i). This is fine for the date Total, but not the summation I require across for the Fund Total.

Example: 2 Fund, A, B. Across 1 date - Jan 2013.

Fund Total (0.6%) <---------------- I would expect to see 0.3% here also, but instead see 0.6%

A Jan 13: (0.3%)

B Jan 13: (0.3%)

Fund total should be ( x(A,i) + x(B,i) )/ (N(A)+N(B))

What happens is I get Summation of x(A,i)/N(A) + x(B,i)/N(B)

Is there anyway of specifying how I can do the Partial Sums at different hierarchal levels in a pivot table in Qlikview?

Re: Partial Sums in Pivot Tables

Gysbert_Wassenaar — Wed, 15 May 2013 11:21:14 GMT

You can use the dimensionality function to find out at which level you are

if(dimensionality() = 1, expression1, expression2)

You may want to start with simply adding dimensionality() as an expression to see the numbers for the levels.

topic Partial Sums in Pivot Tables in QlikView

Partial Sums in Pivot Tables

Re: Partial Sums in Pivot Tables