topic Re: Ignore with multiple conditions in QlikView https://community.qlik.com/t5/QlikView/Ignore-with-multiple-conditions/m-p/1313184#M407949 <HTML><HEAD></HEAD><BODY><P>Try ProductName&lt;&gt;'Total' and 1-sign(WildMatch(ProductName,'*Rest*'))</P></BODY></HTML> Tue, 25 Apr 2017 07:47:23 GMT Anonymous 2017-04-25T07:47:23Z Ignore with multiple conditions https://community.qlik.com/t5/QlikView/Ignore-with-multiple-conditions/m-p/1313183#M407948 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>From my below sample data i need to display only values which are not Total or have Rest in them.</P><P></P><P></P><P>ProductName</P><P>AA</P><P>AA1</P><P>AA3</P><P>AA6</P><P>RestAA</P><P>Total</P><P>BZ</P><P>BZ1</P><P>BZ5</P><P>RestBZ</P><P>Total</P><P></P><P>So, from the above fields in would need my output as below</P><P>AA1</P><P>AA3</P><P>AA6</P><P>BZ</P><P>BZ1</P><P>BZ5</P><P></P><P></P><P></P><P>I have tried writing as If(ProductName&lt;&gt;Total and left(<SPAN style="font-size: 13.3333px;">ProductName,4)=Rest, ProductName). But, this gives me no values.</SPAN></P><P></P><P>TIA!!</P></BODY></HTML> Tue, 25 Apr 2017 07:43:10 GMT https://community.qlik.com/t5/QlikView/Ignore-with-multiple-conditions/m-p/1313183#M407948 psk180590 2017-04-25T07:43:10Z Re: Ignore with multiple conditions https://community.qlik.com/t5/QlikView/Ignore-with-multiple-conditions/m-p/1313184#M407949 <HTML><HEAD></HEAD><BODY><P>Try ProductName&lt;&gt;'Total' and 1-sign(WildMatch(ProductName,'*Rest*'))</P></BODY></HTML> Tue, 25 Apr 2017 07:47:23 GMT https://community.qlik.com/t5/QlikView/Ignore-with-multiple-conditions/m-p/1313184#M407949 Anonymous 2017-04-25T07:47:23Z Re: Ignore with multiple conditions https://community.qlik.com/t5/QlikView/Ignore-with-multiple-conditions/m-p/1313185#M407950 <HTML><HEAD></HEAD><BODY><P>Try placing single quotes properly like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">If(ProductName&lt;&gt;<STRONG>'</STRONG>Total<STRONG>'</STRONG> and left(</SPAN><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">ProductName,4)<STRONG>&lt;&gt;'</STRONG>Rest<STRONG>'</STRONG>, ProductName)</SPAN></P></BODY></HTML> Tue, 25 Apr 2017 07:47:40 GMT https://community.qlik.com/t5/QlikView/Ignore-with-multiple-conditions/m-p/1313185#M407950 tresB 2017-04-25T07:47:40Z Re: Ignore with multiple conditions https://community.qlik.com/t5/QlikView/Ignore-with-multiple-conditions/m-p/1313186#M407951 <HTML><HEAD></HEAD><BODY><P>Missed the single quotes. Such small mistakes eat up lot time <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" />.</P><P></P><P>Thanks both for the quick help. Have a nice day a head!!</P></BODY></HTML> Tue, 25 Apr 2017 07:50:52 GMT https://community.qlik.com/t5/QlikView/Ignore-with-multiple-conditions/m-p/1313186#M407951 psk180590 2017-04-25T07:50:52Z