Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor

How ignore values with special character saved in a variable qlik sense

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:

vFruits.PNG

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 

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Re: How ignore values with special character saved in a variable qlik sense

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