how to show the sum(amount) with positive and negative value in absolute term ?

[Anonymous]

Hi ,

how to show the sum(amount) with positive and negative value in absolute term ? while changing by using fab or any other set analysis the sum(amount) is giving me wrong values ..... how can we achieve this in qlik sense ?

[petter]

Have you tried this?

Negative values:

-Sum( {<amount={'<0'}>} amount )

and

Positive values:

Sum( {<amount={'>0'}>} amount )