https://community.qlik.com/t5/App-Development/True-1-or-False-0/m-p/1944355#M77820 <P>Use FindOneOf()</P> <P>&nbsp;</P> <P>if(<SPAN>FindOneOf</SPAN>(<SPAN>NameLetters,'AB'),-1,0) as NewField</SPAN></P> <P>&nbsp;</P> <P><SPAN><A href="https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/FindOneOf.htm" target="_blank" rel="noopener">https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/FindOneOf.htm</A></SPAN></P> <P><SPAN><A href="https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/SubStringCount.htm" target="_blank">https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/SubStringCount.htm</A></SPAN></P> <P><SPAN><A href="https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFunctions/wildmatch.htm" target="_blank">https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFunctions/wildmatch.htm</A></SPAN></P> <P>&nbsp;</P> Thu, 16 Jun 2022 06:38:44 GMT vinieme12 2022-06-16T06:38:44Z https://community.qlik.com/t5/App-Development/True-1-or-False-0/m-p/1943912#M77775 <P>Hi,</P> <P>I <SPAN>have a table with,&nbsp; a field name, 'NameLetters'. 'NameLetters' consists of different letters, examples A, B, C, D. I need to set these to <STRONG>True or False.</STRONG> That is, if the letter A matches, it should be a True otherwise, it should be False. How do I do that?</SPAN></P> <P>Unfortunately, I can not do this in a simple if-sats, because it is not reset in Qlik -1 or 0.&nbsp;</P> <P>Best regards<BR />Anna&nbsp;</P> Wed, 15 Jun 2022 10:04:33 GMT https://community.qlik.com/t5/App-Development/True-1-or-False-0/m-p/1943912#M77775 annagustafsson 2022-06-15T10:04:33Z https://community.qlik.com/t5/App-Development/True-1-or-False-0/m-p/1943917#M77777 <P>It's not clear what the letter is supposed to match...</P> <P>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. </P> Wed, 15 Jun 2022 10:12:33 GMT https://community.qlik.com/t5/App-Development/True-1-or-False-0/m-p/1943917#M77777 Or 2022-06-15T10:12:33Z https://community.qlik.com/t5/App-Development/True-1-or-False-0/m-p/1943948#M77781 <P>Hi,</P> <P>I need to use&nbsp;<SPAN>0&nbsp; or -1. How do I write this?&nbsp;</SPAN></P> <P>&nbsp;</P> Wed, 15 Jun 2022 10:40:59 GMT https://community.qlik.com/t5/App-Development/True-1-or-False-0/m-p/1943948#M77781 annagustafsson 2022-06-15T10:40:59Z https://community.qlik.com/t5/App-Development/True-1-or-False-0/m-p/1943949#M77782 <P>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.</P> Wed, 15 Jun 2022 10:46:34 GMT https://community.qlik.com/t5/App-Development/True-1-or-False-0/m-p/1943949#M77782 Or 2022-06-15T10:46:34Z https://community.qlik.com/t5/App-Development/True-1-or-False-0/m-p/1944355#M77820 <P>Use FindOneOf()</P> <P>&nbsp;</P> <P>if(<SPAN>FindOneOf</SPAN>(<SPAN>NameLetters,'AB'),-1,0) as NewField</SPAN></P> <P>&nbsp;</P> <P><SPAN><A href="https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/FindOneOf.htm" target="_blank" rel="noopener">https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/FindOneOf.htm</A></SPAN></P> <P><SPAN><A href="https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/SubStringCount.htm" target="_blank">https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/SubStringCount.htm</A></SPAN></P> <P><SPAN><A href="https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFunctions/wildmatch.htm" target="_blank">https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFunctions/wildmatch.htm</A></SPAN></P> <P>&nbsp;</P> Thu, 16 Jun 2022 06:38:44 GMT https://community.qlik.com/t5/App-Development/True-1-or-False-0/m-p/1944355#M77820 vinieme12 2022-06-16T06:38:44Z