Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
petter
Partner - Champion III
Partner - Champion III

Have you tried this?

Negative values:

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

and

Positive values:

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