Discussion Board for collaboration related to QlikView App Development.
I've got a column "DAYS" in a source data file with the following data (week's days):
As you can see, delimiters and symbols are different. How to get the following result in QlikView by the easiest way:
With best regards,
You can try if(wildmatch(field,'*,*')>0,replace(field,',','/'),field)
View solution in original post
Thank you. And we also need to add Capitalize() to convert to the appropriate format.
You can use the UPPER() function of QlikView