topic Count value smaller or bigger then in QlikView https://community.qlik.com/t5/QlikView/Count-value-smaller-or-bigger-then/m-p/380710#M142004 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am pretty new to qlikview and just finished the designer course. Now I am trying to calculate the number of members on an certain date (variabel) but I have no clue how to make this expression...</P><P></P><P>What I want to calculate is:</P><P>Count MemberNumber</P><P>salesdate &lt; variabel1</P><P>validuntill &gt; variabel1</P><P></P><P>Could anyone help me how I should make this into a working expression? So far I didn't find it in the manual...</P><P></P><P>Regards,</P><P>Dennis </P></BODY></HTML> Fri, 24 Aug 2012 12:57:20 GMT 2012-08-24T12:57:20Z Count value smaller or bigger then https://community.qlik.com/t5/QlikView/Count-value-smaller-or-bigger-then/m-p/380710#M142004 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am pretty new to qlikview and just finished the designer course. Now I am trying to calculate the number of members on an certain date (variabel) but I have no clue how to make this expression...</P><P></P><P>What I want to calculate is:</P><P>Count MemberNumber</P><P>salesdate &lt; variabel1</P><P>validuntill &gt; variabel1</P><P></P><P>Could anyone help me how I should make this into a working expression? So far I didn't find it in the manual...</P><P></P><P>Regards,</P><P>Dennis </P></BODY></HTML> Fri, 24 Aug 2012 12:57:20 GMT https://community.qlik.com/t5/QlikView/Count-value-smaller-or-bigger-then/m-p/380710#M142004 2012-08-24T12:57:20Z Re: Count value smaller or bigger then https://community.qlik.com/t5/QlikView/Count-value-smaller-or-bigger-then/m-p/380711#M142005 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>Count(if(salesdate&lt;variable1 and validuntil&gt;variable1,MemberNumber))</P></BODY></HTML> Fri, 24 Aug 2012 13:16:45 GMT https://community.qlik.com/t5/QlikView/Count-value-smaller-or-bigger-then/m-p/380711#M142005 2012-08-24T13:16:45Z Re: Count value smaller or bigger then https://community.qlik.com/t5/QlikView/Count-value-smaller-or-bigger-then/m-p/380712#M142006 <HTML><HEAD></HEAD><BODY><P>Works perfect! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> thanx!</P></BODY></HTML> Fri, 24 Aug 2012 13:19:26 GMT https://community.qlik.com/t5/QlikView/Count-value-smaller-or-bigger-then/m-p/380712#M142006 2012-08-24T13:19:26Z