aggregation in Q12.10 version

[jeevays7]

Hi All,

I have a table like this.

Country	Sec_ID	Value	MTD	Name
A	1	10	0	ABCD
B	1	5	15	ABCD

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

Country	Name	Value	MTD
B	ABCD	15	15

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

Country	Name	Value	MTD
A	ABCD	15	0
B	ABCD	0	15

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...

[sunny_talwar]

Is it possible that the sorting of your data also changed when you upgraded from 11 to 12?

[jeevays7]

Yes,

Some chart sorting order has been changed. but i don't know how it is changing and why?

[sunny_talwar]

Are you aware of any sorting changes in the script of the dashboard or qvd generators?

[jeevays7]

Sorry sunny. i don't know. what should i do?

[sunny_talwar]

What should you do for what?

[jeevays7]

To identify any sorting changes is there or not?

[jeevays7]

But i didn't change any sorting order in in the application and script.

[sunny_talwar]

I mean are you aware of any changes that you made or someone else made? If not, then it might not be because of the sort changes in the script. In general, your expression has a grain mis-match, we can force it to show against B, like this

If(Sum(MTD) <> 0, Sum(Aggr(NODISTINCT Sum(Value),Sec_ID)))

[jeevays7]

If i want to show forcefully, then i need to change some more places? Is there any other solution?