Solved: Tabel Total - Qlik Community

joris_lansdaal · ‎2016-06-09

Hi all,

I've got a pivot table with Months and years. Besides there's a better way to show the data, i'm curious as why the Tabel total for 2014 doesn't match the sum of the cells.

The logic is to show and sum the last 24M (=M24Flag). (expression in the tableheader)

Can anyone tell me why?

PrashantSangle · ‎2016-06-09

hi,

try

sum(aggr(YourExpression,Year,Month))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2016-06-09

hi,

try

sum(aggr(YourExpression,Year,Month))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

joris_lansdaal · ‎2016-06-09

That's the solution. Do you also know why the total is different from the sums?