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...
don't really know, may be someone else can offer any help
Okay, Thank you Sunny.