Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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