Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
dwfiv327
Contributor II
Contributor II

Pivot Table not Summing

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?

9 Replies
Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
dwfiv327
Contributor II
Contributor II
Author

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.

Anil_Babu_Samineni

Can you please post atleast snap for that?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
el_aprendiz111
Specialist
Specialist

Hi,

TOT_PVT.png

dwfiv327
Contributor II
Contributor II
Author

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?

el_aprendiz111
Specialist
Specialist

Hi,

You do not have a qvw sample to help

dwfiv327
Contributor II
Contributor II
Author

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.

el_aprendiz111
Specialist
Specialist

Hi Daniel

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

el_aprendiz111
Specialist
Specialist

expresion.png