Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: having ' (comma) in loading filter criteria?

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

Employee
Employee

Re: having ' (comma) in loading filter criteria?

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

Re: having ' (comma) in loading filter criteria?

Thank you very much

works fine both ways 

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

/A

Not applicable

Re: having ' (comma) in loading filter criteria?

Thank you very much

works fine bothways

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

/A

Community Browser