Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
seniorps
Contributor III
Contributor III

Qlik Sense Pivot Tables - Totals

Hi

I've set up a pivot table based on ageing of transactions, which works great. But the subtotals and total rows don't show the correct amounts from the rows below. It seems that the total rows are not actually adding up the figures that are being calculated at line level, but rather trying to apply the line-level formula logic themselves.

I've attached a screen shot.

Thanks

Paul

1 Reply
sunny_talwar

What is your expression used here? Does it include some kind of if statement? I think if you add Sum(Aggr()) around your expression, you should be able to resolve your issues

Sum(Aggr(YourCurrentExpression, YourChartDimensions))