[ASK] Different result with total Sum Rows

rendiyan — Mon, 25 Jan 2016 08:01:20 GMT

‌

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

Re: [ASK] Different result with total Sum Rows

settu_periasamy — Mon, 25 Jan 2016 16:26:23 GMT

Detailed discussion here