True (-1) or False (0)

[annagustafsson]

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 

[Or]

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.

[annagustafsson]

Hi,

I need to use 0  or -1. How do I write this? 

[Or]

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.

[vinieme12 · Accepted solution]

Use FindOneOf()

if(FindOneOf(NameLetters,'AB'),-1,0) as NewField

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions...

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions...

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFunc...