topic Re: How to select based on expression in QlikView https://community.qlik.com/t5/QlikView/How-to-select-based-on-expression/m-p/585818#M479140 <HTML><HEAD></HEAD><BODY><P>if you as search string use =Count(ID)&gt;1 then it should work. <SPAN style="text-decoration: underline;"><EM>Including</EM></SPAN> the equal sign.</P><P></P><P><IMG alt="Image1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/53187_Image1.png" /></P><P></P><P>HIC</P></BODY></HTML> Fri, 14 Feb 2014 08:47:36 GMT hic 2014-02-14T08:47:36Z How to select based on expression https://community.qlik.com/t5/QlikView/How-to-select-based-on-expression/m-p/585817#M479139 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I want to select those items in a list box that have frequency more than 2. Any way to select it using expression/advance search? I can't get the advance search to work. (i.e. count(ID) &gt; 1)</P></BODY></HTML> Fri, 14 Feb 2014 08:28:45 GMT https://community.qlik.com/t5/QlikView/How-to-select-based-on-expression/m-p/585817#M479139 2014-02-14T08:28:45Z Re: How to select based on expression https://community.qlik.com/t5/QlikView/How-to-select-based-on-expression/m-p/585818#M479140 <HTML><HEAD></HEAD><BODY><P>if you as search string use =Count(ID)&gt;1 then it should work. <SPAN style="text-decoration: underline;"><EM>Including</EM></SPAN> the equal sign.</P><P></P><P><IMG alt="Image1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/53187_Image1.png" /></P><P></P><P>HIC</P></BODY></HTML> Fri, 14 Feb 2014 08:47:36 GMT https://community.qlik.com/t5/QlikView/How-to-select-based-on-expression/m-p/585818#M479140 hic 2014-02-14T08:47:36Z Re: How to select based on expression https://community.qlik.com/t5/QlikView/How-to-select-based-on-expression/m-p/585819#M479141 <HTML><HEAD></HEAD><BODY><P>=count(YourField)&gt;2</P></BODY></HTML> Fri, 14 Feb 2014 08:48:25 GMT https://community.qlik.com/t5/QlikView/How-to-select-based-on-expression/m-p/585819#M479141 maxgro 2014-02-14T08:48:25Z