topic Re: Class Function in QlikView

Class Function

chaitanyajami — Wed, 30 Dec 2015 01:21:38 GMT

hi ,

i have loaded straight table with date interval of Days ,but how ever instead of X as shown in attached table i want to display 'Days' how can i achieve it, thanks for pointers.

Re: Class Function

arulsettu — Wed, 30 Dec 2015 09:53:52 GMT

=replace(class(days,50),'<= x <',' days')

Re: Class Function

kavita25 — Wed, 30 Dec 2015 10:08:52 GMT

try the below expression:

replace(Class(Days,05), '<= x <','Days')

Re: Class Function

MarcoWedel — Thu, 31 Dec 2015 02:29:03 GMT

Hi,

if you just want to replace 'x' with 'days', you better use the third parameter of the Class() function:

Class(Days,50,'Days')

this also keeps the numerical representation of the class values -> no sorting issues.

hope this helps

regards

Marco