TOTAL in straight-table?

[andradinu]

Hi All,

I've created a straight-table and the total for 'OFF_INVOICE ' should be 12,88%

I use this expression:

=1-column(15)/column(13)

Why return me wrong result in Total?

ps:In attached xls is ok,but in qlikview (printscreen) is wrong

Regards,

Andra

[IAMDV]

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

[andradinu]

That is true. I get the correct result using Total Mode (Sum of Rows), but originally was 6,646,269

Regards

Andra

[andradinu]

Possible to work with set Analysis? Does anyone have any idea? Thanks in advance