Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

HimanshuKakade
New Contributor

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


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.

2 Replies
jyothish8807
Honored Contributor II

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

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

Best Regards,
KC
Support
Support

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

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

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.