How to replace a hyphen by a blank value in script?
Hi Qlik community,
I am hoping you could help me with my issue I have been struggling with for so long now.
I use Qlik Sense. There are certain dimensions in Qlik Sense that have '-' . I checked whether these were null values by writing isnull(filedname). The non-null values returned Blank (what was expected) and '-' values returned '-'?
I need these hyphens to have the 'Blank' value because I am applying some applymaps to calculate an additional column.
How do I convert them to be 'Blank' instead of being hyphen?
I am applying a condition : If(isnull(Process), 'Blank', Process) as Process
I am calculating another field based on that one where I do applymaps based on that PRocess field and for some records this field has hyphen as value because there are no values associated. I would like to replace this hyphen by 'Blank' or null to be able to take those lines into account in my calculated field. let me know if you would need more details.