Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jeevays7
Partner - Creator III
Partner - Creator III

aggregation in Q12.10 version

Hi All,

I have a table like this.

CountrySec_IDValueMTDName
A1100ABCD
B1515ABCD

This is the output i am getting in Q11.20 version:

CountryNameValueMTD
BABCD1515


This is the output i am getting in Q12.10 version:

CountryNameValueMTD
AABCD150
BABCD015

Expression for calculating Value is : Sum(Aggr(Sum(Value),Sec_ID))


Expression for calculating MTD is : Sum(MTD)


Why the expression "Sum(Aggr(Sum(Value),Sec_ID))" is working differently in different versions??

i got this difference when i am upgrading my Qlikview from Q11.20 to Q12.10.

Please help me...

11 Replies
sunny_talwar

don't really know, may be someone else can offer any help

jeevays7
Partner - Creator III
Partner - Creator III
Author

Okay, Thank you Sunny.