Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
i have a bunch of values in a field with negative value
is there any command that I can use to remove the negative value aka absolute value.
I tried fabs(value) but the result turns out a different value.
any help is appreciated
You're probably not using the same definition of 'absolute value' as the rest of the world, but fabs(myvalue) returns the absolute value of myvalue. If you want disregard negative values you can use an if statement: if(myvalue>=0,myvalue).
Hi,
fabs() is currect one. Ok try this one
Ex: if(Left(value,1)='-',-1,1)*value
the value turns out to be the same as i use fab.
absolute to my understanding is to change ur negative value (-200) to positive ( 200)
anyway my value is in minutes form, say 200 refers to 200 minutes, it that the reason why it turns out my value to be all in decimal point?
Hi,
Yes, minutes are come decimal point value in qlikview. Read the Date() and Time() Functions.
Refer This Blog
is there any way i can solve this? without changing here and there