Problem with totals to hide records - Qlik Community

Report Inappropriate Content · ‎2012-01-04

Hello,

In the document attached as I can do to make me correctly calculate total pivot table. He is taking intoaccount the record that I have withheld making the entire line return null values to be suppressed.

Regards, Daniel

Miguel_Angel_Baeyens · ‎2012-01-04

Hi Daniel,

That happens when you use a conditional instead of an aggregation expresion, because it has to compare row by row. Go to the chart properties, Expressions tab and click the "Sum of Rows" in "Total Mode", that will return the totals as expected.

Hope that helps.

Miguel

Report Inappropriate Content · ‎2012-01-04

Thanks Miguel, so it clears.
However I have a pivot table in which I intend to do the same but I options are disabled and I can not change to "Mode Total: Sum of Rows" is because you can be?

Regards, Daniel

Report Inappropriate Content · ‎2012-01-04

This attachment is that my other case that will not let me change.

A greeting.

Miguel_Angel_Baeyens · ‎2012-01-04

Hi Daniel,

As discussed, pivot tables don't allow that Total Mode:

http://community.qlik.com/message/176627#176627

Regards.

Miguel

fernandotoledo · ‎2012-01-04

Though you may use AGGR() functions to make an expression that´s behave like the "sum of rows" available in Straight Table.

Report Inappropriate Content · ‎2012-01-04

Can I use the function aggr () in a pivot table for what I'm trying to do? And the expression is made

fernandotoledo · ‎2012-01-04

This file exemplify the use of aggr to simulate an "Sum of Rows" total from a straight table on a pivot table.

Regards,

Fernando

Report Inappropriate Content · ‎2012-01-04

I do not understand your example. Added my attachment not good because then I deleted rows that had intoaccount.

Regards, Daniel

fernandotoledo · ‎2012-01-05

I made the changes in your file, see if it´s like you want to.