Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

class function

How can i remove the '<=' and '>' sign from the result of the class function? Attachaing image for the reference. The formula i have used is:

class(ptn_age, 10).

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

How about Replace?

Replace(Class(ptn_age, 10), '<=x<', '-')

for the dimension or in script?

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Thanks Jonathan for the reply, it worked. Now, one more thing, when i am sorting my dimension values on the basis of numerical value, it is giving me the wrong sort order but when i sort them on the basis of their text value, then it is giving me the right sort order.

Can you explain why?

Images Attached........Numeric_sort.PNGText_sort.PNG