topic Re: Hide Negative values in QlikView

Hide Negative values

NavinReddy — Wed, 15 Jan 2014 13:16:01 GMT

Hi All,

Could some one help me

How can i hide Negative values in chart ,how can i write expression to hide the negative values

Plz help me to know

Thanks in Advance

Niranjan

Re: Hide Negative values

nilesh_gangurde — Wed, 15 Jan 2014 13:18:30 GMT

SUM(if(VALUE < 0 ,0,VALUE))

this type of condition you can put.

-Nilesh

Re: Hide Negative values

Wed, 15 Jan 2014 13:20:21 GMT

Try if(YourField > 0, YourField)

Re: Hide Negative values

Clever_Anjos — Wed, 15 Jan 2014 13:21:38 GMT

rangemin(yourfield,0)

Re: Hide Negative values

NavinReddy — Wed, 15 Jan 2014 13:22:07 GMT

Hi Nilesh,

And i need to make it negative values positive

Regards

Niranjan

Re: Hide Negative values

Clever_Anjos — Wed, 15 Jan 2014 13:24:56 GMT

fabs(yourvalue) if you want negative as positives

Re: Hide Negative values

nilesh_gangurde — Wed, 15 Jan 2014 13:32:59 GMT

Use Fabs Function.

Sum(Fabs(FieldName))

-Nilesh

Re: Hide Negative values

kiranmanoharrode — Wed, 15 Jan 2014 13:36:25 GMT

Hello Niru,

Use Fabs() function which converts all numeric values to Positive.

Regards

Kiran Rode

+91 8976977897

Re: Hide Negative values

aolaleye — Fri, 13 Sep 2019 21:23:12 GMT

Hi All: I used the RangeMax function. RangeMax(Value,0) and it worked. Thanks for all the suggestions.

Re: Hide Negative values

Surya — Sat, 14 Sep 2019 05:43:31 GMT

if u want Hide

If(fieldname > 0,fieldname)

if u want convert negative into positive use

fabs(fieldname)