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