topic Re: Removing negative classes in QlikView

Removing negative classes

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have the following script for calculating a class:

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

I get the following chart:

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

Regards.

Chris

vishsaggi — Wed, 15 Nov 2017 20:59:36 GMT

Did not test but may be try this?

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

Anonymous — Wed, 15 Nov 2017 21:07:10 GMT

Thank you very much Vishwarath, most appreciated.

Regards.

Chris