Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

Hide Negative values

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

9 Replies
nilesh_gangurde
Partner - Specialist
Partner - Specialist

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

this type of condition you can put.

-Nilesh

Not applicable

Try if(YourField > 0, YourField)

Clever_Anjos
Employee
Employee

rangemin(yourfield,0)

NavinReddy
Creator II
Creator II
Author

Hi Nilesh,

And i need to make it negative values positive

Regards

Niranjan

Clever_Anjos
Employee
Employee

fabs(yourvalue) if you want negative as positives

nilesh_gangurde
Partner - Specialist
Partner - Specialist

Use Fabs Function.

Sum(Fabs(FieldName))

-Nilesh

kiranmanoharrode
Creator III
Creator III

Hello Niru,

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

Regards

Kiran Rode

+91 8976977897

aolaleye
Contributor II
Contributor II

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

Surya
Creator II
Creator II

if u want Hide 

If(fieldname > 0,fieldname)

 

if u want convert negative into positive use

fabs(fieldname)