topic Re: class function in QlikView

class function

Wed, 29 Aug 2012 10:41:56 GMT

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).

Re: class function

jonathandienst — Wed, 29 Aug 2012 10:54:05 GMT

How about Replace?

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

for the dimension or in script?

Regards

Jonathan

Re: class function

Wed, 29 Aug 2012 11:02:40 GMT

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........