topic Count value where date 1= date 2 in QlikView https://community.qlik.com/t5/QlikView/Count-value-where-date-1-date-2/m-p/1261660#M397896 <HTML><HEAD></HEAD><BODY><P>Hi, I have the field product ID and I want to count if date 1 = date 2.</P><P></P><P>Product ID&nbsp;&nbsp; Date 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date 2</P><P>22568&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21/02/2017&nbsp;&nbsp;&nbsp;&nbsp; 21/02/2017</P><P>26987&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22/02/2017&nbsp;&nbsp;&nbsp;&nbsp; 23/02/2017</P><P>69854&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23/02/2017&nbsp;&nbsp;&nbsp;&nbsp; 23/02/2017</P><P></P><P>Thank you</P></BODY></HTML> Fri, 24 Feb 2017 09:42:20 GMT iralza01 2017-02-24T09:42:20Z Count value where date 1= date 2 https://community.qlik.com/t5/QlikView/Count-value-where-date-1-date-2/m-p/1261660#M397896 <HTML><HEAD></HEAD><BODY><P>Hi, I have the field product ID and I want to count if date 1 = date 2.</P><P></P><P>Product ID&nbsp;&nbsp; Date 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date 2</P><P>22568&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21/02/2017&nbsp;&nbsp;&nbsp;&nbsp; 21/02/2017</P><P>26987&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22/02/2017&nbsp;&nbsp;&nbsp;&nbsp; 23/02/2017</P><P>69854&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23/02/2017&nbsp;&nbsp;&nbsp;&nbsp; 23/02/2017</P><P></P><P>Thank you</P></BODY></HTML> Fri, 24 Feb 2017 09:42:20 GMT https://community.qlik.com/t5/QlikView/Count-value-where-date-1-date-2/m-p/1261660#M397896 iralza01 2017-02-24T09:42:20Z Re: Count value where date 1= date 2 https://community.qlik.com/t5/QlikView/Count-value-where-date-1-date-2/m-p/1261661#M397897 <HTML><HEAD></HEAD><BODY><P>It depends on your data model. If all fields are in a single table, try like:</P><P></P><P>Count( Distinct {&lt;<SPAN style="font-size: 13.3333px;">[Product ID]</SPAN>={"=Date1=Date2"}&gt;}[Product ID] )</P></BODY></HTML> Fri, 24 Feb 2017 09:47:09 GMT https://community.qlik.com/t5/QlikView/Count-value-where-date-1-date-2/m-p/1261661#M397897 tresB 2017-02-24T09:47:09Z