topic Re: aggregation in Q12.10 version in QlikView

aggregation in Q12.10 version

jeevays7 — Tue, 06 Feb 2018 14:16:53 GMT

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

Re: aggregation in Q12.10 version

sunny_talwar — Tue, 06 Feb 2018 14:34:52 GMT

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

Re: aggregation in Q12.10 version

jeevays7 — Tue, 06 Feb 2018 14:41:38 GMT

Yes,

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

Re: aggregation in Q12.10 version

sunny_talwar — Tue, 06 Feb 2018 14:43:09 GMT

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

Re: aggregation in Q12.10 version

jeevays7 — Tue, 06 Feb 2018 14:56:06 GMT

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

Re: aggregation in Q12.10 version

sunny_talwar — Tue, 06 Feb 2018 14:56:55 GMT

What should you do for what?

Re: aggregation in Q12.10 version

jeevays7 — Tue, 06 Feb 2018 15:07:48 GMT

To identify any sorting changes is there or not?

Re: aggregation in Q12.10 version

jeevays7 — Tue, 06 Feb 2018 15:09:51 GMT

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

Re: aggregation in Q12.10 version

sunny_talwar — Tue, 06 Feb 2018 15:12:07 GMT

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

Re: aggregation in Q12.10 version

jeevays7 — Tue, 06 Feb 2018 15:19:24 GMT

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

Re: aggregation in Q12.10 version

sunny_talwar — Tue, 06 Feb 2018 15:22:00 GMT

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

Re: aggregation in Q12.10 version

jeevays7 — Tue, 06 Feb 2018 15:27:17 GMT

Okay, Thank you Sunny.