topic count if with multiple criteria in QlikView https://community.qlik.com/t5/QlikView/count-if-with-multiple-criteria/m-p/297457#M497417 <HTML><HEAD></HEAD><BODY><P>Test:<BR />{"&gt;=180&lt;240"}</P><P></P><P>Without comma and using double quota</P></BODY></HTML> Wed, 28 Sep 2011 15:16:57 GMT GabrielAraya 2011-09-28T15:16:57Z count if with multiple criteria https://community.qlik.com/t5/QlikView/count-if-with-multiple-criteria/m-p/297456#M497416 <HTML><HEAD></HEAD><BODY><P>Hi. I've been googling and looking around here for some help with count if statements within Qlikview.</P><P></P><P>So far I've managed to use</P><P></P><P>count({&lt; TalkTime = {'&gt;=180,&lt;240'} &gt;}&nbsp; distinct(callerID) )</P><P></P><P>However, the numbers just don't seem to be correct. I have in my database hundreds of call records and want to count those less than 3 minutes, 3-4 minutes etc. The one above should count just those calls which are 3-4 minutes in length. </P><P></P><P>Is this correct? </P><P></P><P>Many thanks</P></BODY></HTML> Wed, 28 Sep 2011 14:53:36 GMT https://community.qlik.com/t5/QlikView/count-if-with-multiple-criteria/m-p/297456#M497416 2011-09-28T14:53:36Z count if with multiple criteria https://community.qlik.com/t5/QlikView/count-if-with-multiple-criteria/m-p/297457#M497417 <HTML><HEAD></HEAD><BODY><P>Test:<BR />{"&gt;=180&lt;240"}</P><P></P><P>Without comma and using double quota</P></BODY></HTML> Wed, 28 Sep 2011 15:16:57 GMT https://community.qlik.com/t5/QlikView/count-if-with-multiple-criteria/m-p/297457#M497417 GabrielAraya 2011-09-28T15:16:57Z count if with multiple criteria https://community.qlik.com/t5/QlikView/count-if-with-multiple-criteria/m-p/297458#M497418 <HTML><HEAD></HEAD><BODY><P>worked a treat - many thanks!!</P></BODY></HTML> Wed, 28 Sep 2011 15:22:33 GMT https://community.qlik.com/t5/QlikView/count-if-with-multiple-criteria/m-p/297458#M497418 2011-09-28T15:22:33Z