Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🤗
it is always
A<=X<Y
u can try using interval match for custom grouping
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.
You can probably adjust your value sub subtracting a min unit like:
=Replace(Replace(Class(YourValue -0.001,10),'<','<='),'<==','<')