Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
syahfira
Partner - Contributor III
Partner - Contributor III

Any function works opposite to CLASS()?

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 🤗

Labels (2)
12 Replies
syahfira
Partner - Contributor III
Partner - Contributor III
Author

I think it won't work for aggregated set analysis that I used in dimension. 

I can't do bucket in load editor because this is a formula calculated on chart level and can't be calculated on script level.

Attached is my set analysis in dimension that I did.

Below picture is my expected output to be present on the chart x - axis.

Thank you.

expected output from the dimension formula I createdexpected output from the dimension formula I created

syahfira
Partner - Contributor III
Partner - Contributor III
Author

Thank you. This is something new for me. Learnt a lot from you. Thanks Vegar.
Vegar
MVP
MVP

Glad to hear that.