Any function works opposite to CLASS()?

[syahfira]

Hi, I'm new to Qlik Sense. 

I have created a formula using Class() function. But it didn't fulfill my expected output.

Class() will give an output like this : a <= x < b

My expected output is this : a < x <= b

Is there any function or way to get my expected output?

Thank you 🤗

[Channa]

it is always

A<=X<Y

u can try using interval match for custom grouping

[Vegar]

What if you class the negative values.

Instead of class(expression) use class(-expression).

You will need to do some string manipulating to get the presentation correct but I believe the class grouping will meet your needs.

[syahfira]

Could you elaborate more on the interval match custom grouping?
Appreciate it so much.
Thank you.

[syahfira]

Hi. Thank you for the suggestion.
Unfortunately, it won't work for the class grouping.
Thank you.

[Vegar]

This page should be a good place to start.
https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Sc...

In the example you could consider OrderLog as the table defining your intervals and EventLog containing the numeric fields in which you want to define a interval for.

[vireshkolagimat]

Hi, try using something like below as calculated dimension.

=replace(replace(class(age,10),'<','<='),'<==','<')

In the above case, i took age as dimension and added it as a calculated dimension.

Regards,
Viresh

[syahfira]

Hello. Thank you for replying. 

Actually, you have replacing the sign only. It won't change for the value to fall into the respective class.

This is not the right approach.

[tresesco]

You can probably adjust your value sub subtracting a min unit like:

=Replace(Replace(Class(YourValue -0.001,10),'<','<='),'<==','<') 

[Vegar]

You could do like I've done in the picture below.