Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table with, a field name, 'NameLetters'. 'NameLetters' consists of different letters, examples A, B, C, D. I need to set these to True or False. That is, if the letter A matches, it should be a True otherwise, it should be False. How do I do that?
Unfortunately, I can not do this in a simple if-sats, because it is not reset in Qlik -1 or 0.
Best regards
Anna
Use FindOneOf()
if(FindOneOf(NameLetters,'AB'),-1,0) as NewField
It's not clear what the letter is supposed to match...
Qlik has True() and False() available. You can also use 0 (False) or -1 (True) if you prefer those to the functions for whatever reason.
Hi,
I need to use 0 or -1. How do I write this?
I don't know how you'd write it, as it's not clear what your requirement is. Letters are supposed to match something, but you didn't explain what.
Use FindOneOf()
if(FindOneOf(NameLetters,'AB'),-1,0) as NewField