Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
guptanupur
Contributor II
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 ?

5 Replies
siddharth_s3
Partner
Partner

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

guptanupur
Contributor II
Contributor II
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
Partner

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

Try

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