topic Re: Issue with AGGR function in Pivot Table | Qlikview Migration from 11.20 to 12.20 in QlikView

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

HimanshuKakade — Sat, 16 Nov 2024 03:21:04 GMT

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.

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

jyothish8807 — Tue, 11 Jun 2019 07:16:17 GMT

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

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

Brett_Bleess — Thu, 11 Jul 2019 21:14:52 GMT

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/NestedAggregations/sum-of-rows-pivot-tables.htm

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