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: 
Anonymous
Not applicable

Removing negative classes

I have the following script for calculating a class:

=Dual(Replace(Class(Amount,10), '<= x <', ' - '), Class(Amount,10))

I get the following chart:

ItemValueClass.JPG

How do i change the script to get rid of the highlighted negative class?

Regards.

Chris

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

Did not test but may be try this?

=Dual(Replace(Class(IF(Amount>0, Amount),10), '<= x <', ' - '), Class(Amount,10))

View solution in original post

2 Replies
vishsaggi
Champion III
Champion III

Did not test but may be try this?

=Dual(Replace(Class(IF(Amount>0, Amount),10), '<= x <', ' - '), Class(Amount,10))

Anonymous
Not applicable
Author

Thank you very much Vishwarath, most appreciated.

Regards.

Chris