Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
];
Thank you very much
works fine both ways
If([SB Brand] Like 'Jacob'&chr(39)&'s*', 'Jacob'&chr(39)&'s Creek',
/A
Thank you very much
works fine bothways
If([SB Brand] Like 'Jacob'&chr(39)&'s*', 'Jacob'&chr(39)&'s Creek',
/A