topic absolute value in QlikView

absolute value

n1ef5ng1 — Wed, 08 May 2013 10:06:01 GMT

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

Re: absolute value

Gysbert_Wassenaar — Wed, 08 May 2013 10:09:50 GMT

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).

Re: absolute value

kumarnatarajan — Wed, 08 May 2013 10:10:26 GMT

Hi,

fabs() is currect one. Ok try this one

Ex: if(Left(value,1)='-',-1,1)*value

Re: absolute value

n1ef5ng1 — Wed, 08 May 2013 10:13:44 GMT

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?

Re: absolute value

kumarnatarajan — Wed, 08 May 2013 10:18:50 GMT

Hi,

Yes, minutes are come decimal point value in qlikview. Read the Date() and Time() Functions.

Refer This Blog

www.qlikviewaddict.com

Re: absolute value

n1ef5ng1 — Wed, 08 May 2013 10:21:30 GMT

is there any way i can solve this? without changing here and there