topic Re: Pivot Table not Summing in QlikView

Pivot Table not Summing

dwfiv327 — Mon, 12 Jun 2017 17:04:51 GMT

I have a pivot table with several expressions. On all of them I switched over to straight table view and selected SUM for Total Mode. The totals are correct. When I switch back to Pivot table, one of the columns gives me the Expression Total instead of the sum.

How can I force the pivot table to SUM the expressions instead of computing the Expression Total?

Re: Pivot Table not Summing

Anil_Babu_Samineni — Mon, 12 Jun 2017 17:20:17 GMT

May be in Pivot table you need some aggregation like Sum(your expression) or Sum(Aggr(your expression), dimensions))

Re: Pivot Table not Summing

dwfiv327 — Mon, 12 Jun 2017 18:03:17 GMT

Should not matter what formula I use for the field, when I ask for totals to be SUM of field, it should give a SUM and not reevaluate the formula for the total. It is looking like a bug in QlikView.

Re: Pivot Table not Summing

Anil_Babu_Samineni — Mon, 12 Jun 2017 18:05:26 GMT

Can you please post atleast snap for that?

Re: Pivot Table not Summing

el_aprendiz111 — Mon, 12 Jun 2017 21:13:55 GMT

Hi,

Re: Pivot Table not Summing

dwfiv327 — Tue, 13 Jun 2017 14:14:25 GMT

Yes, I have "Show Partial Sums" checked, but the Pivot table does not sum the column, it computes the formula on all entries in the column, which is not the same thing.

How do I get it to actually SUM the column?

Re: Pivot Table not Summing

el_aprendiz111 — Tue, 13 Jun 2017 16:24:07 GMT

Hi,

You do not have a qvw sample to help

Re: Pivot Table not Summing

dwfiv327 — Tue, 13 Jun 2017 18:00:31 GMT

Here is a little sample that illustrates the problem. The sum of the expression in the Pivot table and in the Straight table are not the same.

Re: Pivot Table not Summing

el_aprendiz111 — Tue, 13 Jun 2017 19:29:57 GMT

Hi Daniel

Expressions:sum(Aggr(sum(Value)/sum(Month),Name))

Re: Pivot Table not Summing

el_aprendiz111 — Tue, 13 Jun 2017 19:31:55 GMT