Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello qlikview developers,
i have an issue i want to ask.
so i have a straight table with dimension A, B, and ABC expression.
My expression formula is :
If(sum(A)/sum(B)>1,1,sum(A)/sum(B))* sum(C)
Also i give total of rows sum in my straight table.
And then i create a pivot table with same dimension and expression as above.
Here's when the strange thing happen.
When i expand all dimension, i got the same row result.
But when i only expand for dimension A, i got the different result from the total of rows sum in my straight table.
Is there any explanation why and how to solve this?
Thanks a lot before,
Best Regards
Detailed discussion here