Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

having ' (comma) in loading filter criteria?

Hi all - new to qlik sense,

I have an if statement in my loading where I need to test field A being like 'd'anglo*' (and some similar). Is there a way to enable that so qlik don't take that for a text separator (which it does). I have tried putting double quotes around the comma and double single commas without success ('d"'"angelo' and 'd'''angelo')

Thanks

4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

you can use the chr(39) function to represent the single quote. A little clunky but it looks like this:

'd' & chr(39) & 'anglo*'


-Rob

http://masterssummit.com

http://robwunderlich.com

ToniKautto
Employee
Employee

You can use the Chr() fucntion to generate a character. The input value is the decimal index of the ASCII table. Single quote is equal to Chr(39).

T1:

LOAD

  F1,

  If(F1 = 'd'&Chr(39)&'anglo', 1, 0) AS F2

Inline [

F1

d'anglo

];

Not applicable
Author

Thank you very much

works fine both ways 

If([SB Brand] Like 'Jacob'&chr(39)&'s*', 'Jacob'&chr(39)&'s Creek',

/A

Not applicable
Author

Thank you very much

works fine bothways

  If([SB Brand] Like 'Jacob'&chr(39)&'s*', 'Jacob'&chr(39)&'s Creek',

/A