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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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).

Labels (1)
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