topic Set Analysis for 'Does Not Contain' in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-for-Does-Not-Contain/m-p/1092598#M644644 <HTML><HEAD></HEAD><BODY><P>Is there a way to create an expression through Set-Analysis with a 'Does Not Contain' or a 'Does not Begin With' statement?</P></BODY></HTML> Thu, 14 Jan 2016 20:45:32 GMT 2016-01-14T20:45:32Z Set Analysis for 'Does Not Contain' https://community.qlik.com/t5/QlikView/Set-Analysis-for-Does-Not-Contain/m-p/1092598#M644644 <HTML><HEAD></HEAD><BODY><P>Is there a way to create an expression through Set-Analysis with a 'Does Not Contain' or a 'Does not Begin With' statement?</P></BODY></HTML> Thu, 14 Jan 2016 20:45:32 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-Does-Not-Contain/m-p/1092598#M644644 2016-01-14T20:45:32Z Re: Set Analysis for 'Does Not Contain' https://community.qlik.com/t5/QlikView/Set-Analysis-for-Does-Not-Contain/m-p/1092599#M644645 <HTML><HEAD></HEAD><BODY><P>Sure</P><P></P><P>Does Not Contain:</P><P><STRONG>{&lt;FieldName <SPAN style="color: #ff0000; font-size: 12pt;">-</SPAN>= {'This', 'This1'}&gt;}</STRONG></P><P></P><P>Does not Begin With:</P><P><STRONG>{&lt;FieldName <SPAN style="color: #ff0000; font-size: 12pt;">-</SPAN>= {'Th*'}&gt;}</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Note the negative sign ( <SPAN style="color: #ff0000; font-size: 12pt;">-</SPAN> ) before the equals sign (=)<BR /></STRONG></P></BODY></HTML> Thu, 14 Jan 2016 21:28:44 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-Does-Not-Contain/m-p/1092599#M644645 sunny_talwar 2016-01-14T21:28:44Z Re: Set Analysis for 'Does Not Contain' https://community.qlik.com/t5/QlikView/Set-Analysis-for-Does-Not-Contain/m-p/1092600#M644646 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Tue, 22 Mar 2016 20:12:05 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-Does-Not-Contain/m-p/1092600#M644646 2016-03-22T20:12:05Z Re: Set Analysis for 'Does Not Contain' https://community.qlik.com/t5/QlikView/Set-Analysis-for-Does-Not-Contain/m-p/1092601#M644647 <HTML><HEAD></HEAD><BODY><P>If this answers your question, flag his reply as "Correct Answer".</P><P>If not, please make clear what part of your question you still need help with.</P></BODY></HTML> Tue, 22 Mar 2016 20:22:18 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-for-Does-Not-Contain/m-p/1092601#M644647 oknotsen 2016-03-22T20:22:18Z