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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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.

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

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