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 ?

[siddharth_s3]

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

[YoussefBelloum]

Hi,

you will need fabs()

https://help.qlik.com/fr-FR/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/GeneralNu...

[Anonymous]

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]

Hi,

you must tell :

fabs(sum(total <your break> amount)

if not, it's done for each row

regards

[devyanshu_gupta]

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

Try

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