Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following values saved in a variable called "vFruits":
Apple |
Mango |
Cabbage |
Mango's |
I am trying to map those values based on a conditions with the following code: if(Wildmatch("GMID",($(vFruits)))>0,ApplyMap('MAP_GMID',"GMID"),"GMID Desc") as "GMID Name"
But When i load my script i have an error caused by an apostrohe special character found in the value "Mango's". Here is the Qlik sense error:
Is there please a way to ignore that special character and keep the values as it is in my condition?
Thanks for your help.
Regards,
Tatiana
You may remove this char by creating the variable, for example with something like: purgechar(YourValue, chr(39)) whereby you will need to do the same within your other data because otherwise they wouldn't match anymore or you could double this char like: replace(YourValue, chr(39), chr(39) & chr(39)).
- Marcus