When you goto the granular level it will compute the expression Sum([Bales Loaded]) - Sum([Bales Delivered]) might be different from the on at the high level
Region, SomeID, [Bales Loaded], [Bales Delivered]
NY, 1, 20, 10
NY, 2, 20, 40
when u see at the ID level
NY 1 20-10<=0? gives 10
NY 2 20-40<=0? gives 0
What if on Region level
NY 40 - 50<=0? gives 0 instead of 10 right?
Thats how qlikview will do the operation by default.
Here to achieve yours use Aggr, which might slower but you needed here.
Aggr(If((Sum([Bales Loaded])-Sum([Bales Delivered])), 0, Sum(Sum([Bales Loaded])-Sum([Bales Delivered]))), SomeID, Region)
Then you will get your desired result
Thanks Celambarsan, I think its gone a little bit worse actual,
I have attached some dummy data, hope this works, would you mind taking a look.
Sampple Data.qvw 150.0 K