Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Total Pivot Table vs Total Straight Table

Dear Gurús, 

I'm doing a complex Aggr calculation in QlikSense and my problem is that the Total Result is working OK in a Straight Table but the Totals if I use a Pivot Table is wrong. I know there are some posts related to this topic but none of them are using similar formulas... This is the formula I'm using: 

sum(AGGR((RangeMax (0, sum({<[Delivery Indicator]-={'X'}>}[Purchase Quantity]) - sum({<[Delivery Indicator]-={'X'}>}[Received Quantity]))) ,[Order - Position]))

Any idea of how can I apply this formula into a Pivot Table and see the correct Totals when I analyze this by any dimension?

Thanks!!!

Labels (1)
0 Replies