Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 (1)
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.