topic Re: PIVOT Partial Sums in QlikView

PIVOT Partial Sums

bsbernabe — Wed, 18 Oct 2017 09:02:40 GMT

Hi,

I have pivot Table, base on my observation the Partial Sums is not equal to Total Sum, I am trying to get the Max for EVALUATED_PRICE, here my script in expression max(EVALUATED_PRICE) but the Total Partial Sum is not equal see below screenshot

Suppose to be :

32,640 24,160

28,400 24,160

61,040 48,320

Best Regards,

Bing

Re: PIVOT Partial Sums

Anil_Babu_Samineni — Wed, 18 Oct 2017 09:08:16 GMT

Please attachr QVW

Re: PIVOT Partial Sums

antoniotiman — Wed, 18 Oct 2017 09:23:21 GMT

Try this

Sum(Aggr(Max(EVALUATED_PRICE),Dim1,Dim2,Dim3))

Re: PIVOT Partial Sums

jonathandienst — Wed, 18 Oct 2017 09:30:46 GMT

You need a Sum of rows type of expression, like:

Sum(Aggr(Max(EVALUATED_PRICE), [MATERIAL GROUP DESCRIPTION], [YEAR SOLD (BN)], CATEGORY, [MATERIAL DESCRIPTION]))

(You need all the pivot dimensions in the Aggr - I am assuming that they are the bold fields, Change if necessary)

Re: PIVOT Partial Sums

bsbernabe — Wed, 18 Oct 2017 23:22:33 GMT

Hi Jonathan,

It's working thank you so much for your support i really appreciate.

Best Regard

Bing