Qlik Community

Qlik Sense App Development

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

seniorps
New Contributor II

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

Re: Qlik Sense Pivot Tables - Totals

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))

Community Browser