topic Re: How to count records with two numeric conditions in QlikView https://community.qlik.com/t5/QlikView/How-to-count-records-with-two-numeric-conditions/m-p/985992#M646957 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Count(DISTINCT {&lt;dayss ={'&gt;=0&lt;=7'}&gt;}[CONTRATOi])</STRONG></SPAN></P></BODY></HTML> Thu, 12 Nov 2015 14:52:46 GMT sunny_talwar 2015-11-12T14:52:46Z How to count records with two numeric conditions https://community.qlik.com/t5/QlikView/How-to-count-records-with-two-numeric-conditions/m-p/985990#M646955 <HTML><HEAD></HEAD><BODY><P>I need to count the records that have values between 0 and&nbsp; 7,&nbsp; I`m using the included expression, but with this one it count also records in negative</P><P></P><P></P><P></P><P>count(DISTINCT {&lt;dayss ={'&lt;=7'}&gt;}[CONTRATOi])<BR /> </P><P><SPAN class="mce_paste_marker"></SPAN></P></BODY></HTML> Thu, 12 Nov 2015 14:06:01 GMT https://community.qlik.com/t5/QlikView/How-to-count-records-with-two-numeric-conditions/m-p/985990#M646955 2015-11-12T14:06:01Z Re: How to count records with two numeric conditions https://community.qlik.com/t5/QlikView/How-to-count-records-with-two-numeric-conditions/m-p/985991#M646956 <HTML><HEAD></HEAD><BODY><P>I found the solutions..</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">({ $&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">dayss</SPAN><SPAN style="font-size: 8pt;">={'&gt;0&lt;=7'}&gt;} </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">distinct</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">CONTRATOi</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Thu, 12 Nov 2015 14:52:00 GMT https://community.qlik.com/t5/QlikView/How-to-count-records-with-two-numeric-conditions/m-p/985991#M646956 2015-11-12T14:52:00Z Re: How to count records with two numeric conditions https://community.qlik.com/t5/QlikView/How-to-count-records-with-two-numeric-conditions/m-p/985992#M646957 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Count(DISTINCT {&lt;dayss ={'&gt;=0&lt;=7'}&gt;}[CONTRATOi])</STRONG></SPAN></P></BODY></HTML> Thu, 12 Nov 2015 14:52:46 GMT https://community.qlik.com/t5/QlikView/How-to-count-records-with-two-numeric-conditions/m-p/985992#M646957 sunny_talwar 2015-11-12T14:52:46Z Re: How to count records with two numeric conditions https://community.qlik.com/t5/QlikView/How-to-count-records-with-two-numeric-conditions/m-p/985993#M646958 <HTML><HEAD></HEAD><BODY><P>the other way,</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">count(DISTINCT {&lt;dayss ={'0','1','2','3','4','5','6','7'}&gt;}[CONTRATOi])</SPAN></P></BODY></HTML> Thu, 12 Nov 2015 14:56:15 GMT https://community.qlik.com/t5/QlikView/How-to-count-records-with-two-numeric-conditions/m-p/985993#M646958 buzzy996 2015-11-12T14:56:15Z Re: How to count records with two numeric conditions https://community.qlik.com/t5/QlikView/How-to-count-records-with-two-numeric-conditions/m-p/985994#M646959 <HTML><HEAD></HEAD><BODY><P>you can close your thread </P></BODY></HTML> Thu, 12 Nov 2015 15:13:02 GMT https://community.qlik.com/t5/QlikView/How-to-count-records-with-two-numeric-conditions/m-p/985994#M646959 ramoncova06 2015-11-12T15:13:02Z