topic Adjusting Class Ranges in QlikView

Adjusting Class Ranges

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

I have the following classes:

These were calculated using the following script:

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

Is there a way of changing the class and making them not to overlap like as follows:

Regards

Chris

Anonymous — Wed, 15 Nov 2017 23:38:30 GMT

I used the following script after Googling and finding a solution from the community posted by one Jonathan Poole. Thanks Jonathan:

=Left(Class(Amount, 10), FindOneOf(Class(Amount, 10), ' ',1))
& ' - ' &
(Num(Mid(Class(Amount,10), FindOneOf(Class(Amount, 10), ' ',4)))-1)

Chris