Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
HimanshuKakade
Contributor
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
Master II
Master II

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

Best Regards,
KC
Brett_Bleess
Support (Former)
Support (Former)

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 do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.