Straight table total not respect row rules

[martina_ag]

I'm using a straight table (see below) that calculate 4 measure: contract_value, SIL, P.O. (=contract_value - sil), P.O._v2 where the minus 0 differences are replaced with 0.

This are the formulas I used:

P.O = CONTRACT_VALUE - SIL

P.O._V2 = if ( [IMPORTO CONTRATTO (C)]-SIL < '0' ,'0',[IMPORTO CONTRATTO (C)]-SIL)

As you can see, for each row the measure P.O._v2 is right, but the column Total does not work (is the the same of P.O. column).

Someone has an idea of what I could do to fix it?

[igoralcantara · Accepted solution]

The issue is because the default behavior of totals in straight tables in Qlik aggregates the column values directly (e.g., sums them up) instead of recalculating the expression logic for the total row.

To fix this, you need to adjust your P.O._V2 expression properties.

[martina_ag]

Thank you so much!!!