Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

guptanupur
New Contributor II

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

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 ?

1 Reply
MVP
MVP

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

Have you tried this?

Negative values:

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

and

Positive values:

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