Issue with AGGR function in Pivot Table | Qlikview Migration from 11.20 to 12.20

[HimanshuKakade]

Hi,

When a dashboard developed in 11.20 is migrated to 12.20, the pivot table containing AGGR function is breaking.
The Dashboard is showing different values in 11.20 and 12.20 environment.

Below are the high level details. We have following columns.
Gender, Year, Region, Grade, ID

We have a pivot table where we have Region as a dimension and pivoted the count it by Year.
We are using following expression for Count.

= num(
num(sum({<GENDER={'M'},[Year]=>}
aggr(Count( {<GENDER={'M'}, [Year]=>} ID), [Year], Grade))
,'###,###.')
+
num(sum({<GENDER={'F'}, [Year]=>}
aggr(Count( {<GENDER={'F'}, [Year]=>} ID), [Year], Grade))
,'###,###.')
,'###,###.')

Is there any known issue of AGGR in Pivot Table for Qlikview 12.20?
Kindly help.

[jyothish8807]

Can you share a sample data and show the difference you are seeing after the migration ?

[Brett_Bleess]

Have a look at the following, not sure it is really of any help, but it might be:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Here are some Design Blog posts as well that may potentially shed some further light upon things too:

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-get-aggr-avated-using-aggr/ba-p/1464136

https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275

There are a few more out there, but I am hoping one of these two may help.

Regards,
Brett