topic Problems with partial sum in a pivot table in QlikView

Problems with partial sum in a pivot table

Tue, 26 Jan 2010 16:17:54 GMT

Dear All,

I have a pivot table that shows data groups in rows, months in columns and "COUNT(TransactionNumber) * Price" in expression. When I check partial sum for months (columns) I get it right but when I check partial sum for data groups (rows) pivot doesn't show it.

I've put Price dim into SUM(Price) and got the partial sum but incorrect (att. screen shot).

Please advise how to fix it.

BR,

Przemek

Problems with partial sum in a pivot table

Tue, 26 Jan 2010 16:58:16 GMT

Hi,

If your input data are transactionnal, just put Sum(Price) in the pivot table, you don't need to count the number of transaction.

Problems with partial sum in a pivot table

Tue, 26 Jan 2010 17:16:26 GMT

The name "TransactionNumber" might be misleading - the whole formula counts number of records within a data group to multiply it by Price and get final cost. To sum up, COUNT(TransactionNumber) has to stay.

BR,

Przemek

Problems with partial sum in a pivot table

Wed, 08 Jun 2011 20:15:36 GMT

Hi Przemek,

I ran into a similar problem. My partial sum is correct for the dimension that I have used,

but the group of rows or the individual rows gives me different values. It seem they adjust

themselves based on the total.

Could you please suggest me what step should I take to come out of this issue?

Thanks and best regards,

Bikash

Problems with partial sum in a pivot table

Thu, 13 Oct 2011 23:25:34 GMT

did u guys solve this issue? I ran into similar situation

Problems with partial sum in a pivot table

Sokkorn — Fri, 14 Oct 2011 00:56:12 GMT

Hi Przemek,

Can you attahced your report? Then we will try to find problem together.

Regards,

Sokkorn

Problems with partial sum in a pivot table

SunilChauhan — Fri, 14 Oct 2011 05:32:47 GMT

coovert your pivot table into straight table

go to prroperties-> expression

-> select expression-.check sum of rows in place of Expression total

apply

and then again convert into pivot table

Re: Problems with partial sum in a pivot table

jonathandienst — Fri, 14 Oct 2011 05:50:17 GMT

Przemek

I suspect the problem is that Price is not unique for the total that it not working, so Price returns null and your sum returns zero. I have found in this case that an aggregate fixes the problem. Try something like

Sum(Aggr(Count(TransactionNumber) * Price, Month, DataGroup))

Hope this helps

Jonathan

Problems with partial sum in a pivot table

Fri, 14 Oct 2011 16:21:26 GMT

Sunil, I tried it earlier but that didnt work

Problems with partial sum in a pivot table

Fri, 14 Oct 2011 16:28:18 GMT

John,

My case is something like

dimensions

If(condition is true,if(Condition is true, ( Tablecolumn)))

Month

Expression

=Count(stuff)+Count(Stuff)

// its actually a 2 line expression

i tried using ur eample

Sum(Aggr(Count(stuff)+Count(Stuff), Month,

If(condition is true,if(Condition is true, ( Tablecolumn)))))

but its showing '0'