topic Button to search and exclude 1 value in QlikView https://community.qlik.com/t5/QlikView/Button-to-search-and-exclude-1-value/m-p/354663#M131628 <HTML><HEAD></HEAD><BODY><P>I have a button set up that currently does this...</P><P></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P>(5*|6*|2*|*118429308*) </P><P></P><P>It takes all data in my field that starts with 5, 6, 2, and is 118429308.</P><P></P><P>I have another button that does this...</P><P></P><P></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P>(1*|0*|8*|7*) </P><P></P><P></P><P>It takes all data in my field that starts with 1, 0, 8, and 7. However, I want it to exclude the number 118429308 even though it starts with a 1.</P><P><SPAN style="font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P></BODY></HTML> Fri, 15 Jun 2012 13:09:49 GMT 2012-06-15T13:09:49Z Button to search and exclude 1 value https://community.qlik.com/t5/QlikView/Button-to-search-and-exclude-1-value/m-p/354663#M131628 <HTML><HEAD></HEAD><BODY><P>I have a button set up that currently does this...</P><P></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P>(5*|6*|2*|*118429308*) </P><P></P><P>It takes all data in my field that starts with 5, 6, 2, and is 118429308.</P><P></P><P>I have another button that does this...</P><P></P><P></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P>(1*|0*|8*|7*) </P><P></P><P></P><P>It takes all data in my field that starts with 1, 0, 8, and 7. However, I want it to exclude the number 118429308 even though it starts with a 1.</P><P><SPAN style="font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P></BODY></HTML> Fri, 15 Jun 2012 13:09:49 GMT https://community.qlik.com/t5/QlikView/Button-to-search-and-exclude-1-value/m-p/354663#M131628 2012-06-15T13:09:49Z Re: Button to search and exclude 1 value https://community.qlik.com/t5/QlikView/Button-to-search-and-exclude-1-value/m-p/354664#M131629 <HTML><HEAD></HEAD><BODY><P>in search use this exp&nbsp; =sum({} 1)</P></BODY></HTML> Fri, 15 Jun 2012 14:28:28 GMT https://community.qlik.com/t5/QlikView/Button-to-search-and-exclude-1-value/m-p/354664#M131629 Siva_Sankar 2012-06-15T14:28:28Z Re: Button to search and exclude 1 value https://community.qlik.com/t5/QlikView/Button-to-search-and-exclude-1-value/m-p/354665#M131630 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; font-size: 12px; color: #636363; font-family: Arial;">see an extraordinary solution here :</P><P style="background-color: #ffffff; font-size: 12px; color: #636363; font-family: Arial;"><A _jive_internal="true" href="https://community.qlik.com/message/229000#229000" style="color: #007fc0;">http://community.qlik.com/message/229000#229000</A></P></BODY></HTML> Fri, 15 Jun 2012 14:31:53 GMT https://community.qlik.com/t5/QlikView/Button-to-search-and-exclude-1-value/m-p/354665#M131630 giakoum 2012-06-15T14:31:53Z