Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I've created a straight-table and the total for 'OFF_INVOICE ' should be 12,88%
I use this expression:
Why return me wrong result in Total?
ps:In attached xls is ok,but in qlikview (printscreen) is wrong
Regards,
Andra
Thank you.
I have discovered one more problem with [Monthly Trend] field which contains a reference to Column(9). If I copy the expression definition from Column(9) instead of "Column(9)" then I get a different total. I'm getting 6,646,269 instead of 11,135,509 and this is causing lot of noise.
Can you test the same and update me if you encounter the same problem?
Cheers,
DV
That is true. I get the correct result using Total Mode (Sum of Rows), but originally was 6,646,269
Regards
Andra
Possible to work with set Analysis? Does anyone have any idea? Thanks in advance