Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Is it possible that the sorting of your data also changed when you upgraded from 11 to 12?
Yes,
Some chart sorting order has been changed. but i don't know how it is changing and why?
Are you aware of any sorting changes in the script of the dashboard or qvd generators?
Sorry sunny. i don't know. what should i do?
What should you do for what?
To identify any sorting changes is there or not?
But i didn't change any sorting order in in the application and script.
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)))
If i want to show forcefully, then i need to change some more places? Is there any other solution?