topic Re: Totals in pivot table in QlikView

Totals in pivot table

Anonymous — Mon, 02 Dec 2013 14:11:16 GMT

Hi everyone,

I'm facing a problem with my development. I'm using a pivot table with 3 expressions:

Sum(Quantity), Sum(Pieces) and Sum(Quantity) / Sum(Pieces).

What I want is the total of the rows on each of these expressions. But, on the third column, the total is equivalent to TOTAL(Quantity)/TOTAL(Pieces) and not the sum of rows.

On my example below, I need to have 322 instead of 121.

I know I can fix this problem by using a simple table but I really need a pivot table.

Is there a solution to fix this ?

Thanks a lot,

Quentin

Re: Totals in pivot table

Gysbert_Wassenaar — Mon, 02 Dec 2013 14:22:24 GMT

You will have to use the aggr function:

sum(aggr(Sum(Quantity) / Sum(Pieces),Dim1, Dim2, ..., DimN))

Replace Dim1, Dim2, ...,DimN with the dimensions of your pivot table.

Re: Totals in pivot table

saumyashah90 — Mon, 02 Dec 2013 14:26:48 GMT

I am not sure,

If you can customize that function in expression itself

Re: Totals in pivot table

Anonymous — Mon, 02 Dec 2013 15:08:21 GMT

Hi guys,

Thanks for your answer. Unfortunately, my dimensions are three cyclic groups and the period, so I tried to use your formula on my group and on all the dimensions in this group, it didn't work well.

Re: Totals in pivot table

Tue, 10 Dec 2013 22:00:28 GMT

Hi Guys , can you help me on below link ?

Pivot table how to use Aggr to compute Diff % ?