Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Partner
Partner

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
Highlighted
arulsettu
Honored Contributor III

Re: Class Function

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

Highlighted
Partner
Partner

Re: Class Function

try the below expression:

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

Highlighted

Re: Class Function

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