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: 
chaitanyajami
Partner - Creator
Partner - Creator

Class Function

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.

Labels (1)
3 Replies
arulsettu
Master III
Master III

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

kavita25
Partner - Specialist
Partner - Specialist

try the below expression:

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

MarcoWedel
MVP
MVP

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