Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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 ?

5 Replies
siddharth_s3
Partner - Creator II
Partner - Creator II

Give an example. I don't get your need exactly.

Anonymous
Not applicable
Author

now suppose i have amount as -100, 100 , 20,-80  if I give sum of these amount it will be -60 and in my chart it will show as -60 ....but I want to show the abs value in my chart as 60

I used fabs(sum(amount)) it is giving me value as 300 (which is not correct)

is there any other expression or formula to get absolute 60 .??

ogautier62
Specialist II
Specialist II

Hi,

you must tell :

fabs(sum(total <your break> amount)

if not, it's done for each row

regards

devyanshu_gupta
Partner - Contributor III
Partner - Contributor III

If fabs is giving the wrong result try using "SIGN" function

Try

=Sum(Amount)*Sign(Sum(Amount))