topic count distinct calculation in QlikView https://community.qlik.com/t5/QlikView/count-distinct-calculation/m-p/228146#M80202 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P>How can i make something like this?(this is wrong, i know but i need only the shipdate-duedate for the distinct orderid)</P><P></P><P>=count(Distinct OrderID if((ShipDate-DueDate)&lt;=0,1))</P><P>TNX</P><P>Timmy</P><BR /><BR /></BODY></HTML> Tue, 20 Jul 2010 15:15:42 GMT timmy 2010-07-20T15:15:42Z count distinct calculation https://community.qlik.com/t5/QlikView/count-distinct-calculation/m-p/228146#M80202 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P>How can i make something like this?(this is wrong, i know but i need only the shipdate-duedate for the distinct orderid)</P><P></P><P>=count(Distinct OrderID if((ShipDate-DueDate)&lt;=0,1))</P><P>TNX</P><P>Timmy</P><BR /><BR /></BODY></HTML> Tue, 20 Jul 2010 15:15:42 GMT https://community.qlik.com/t5/QlikView/count-distinct-calculation/m-p/228146#M80202 timmy 2010-07-20T15:15:42Z count distinct calculation https://community.qlik.com/t5/QlikView/count-distinct-calculation/m-p/228147#M80203 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I haven't tested this so apologies if my guess is completely wrong, could you try:</P><P>=Count ( Distinct ( If ( ShipDate - DueDate &lt;= 0 , OrderId ) ) )</P><P></P><P>Regards,</P></BODY></HTML> Tue, 20 Jul 2010 15:27:33 GMT https://community.qlik.com/t5/QlikView/count-distinct-calculation/m-p/228147#M80203 2010-07-20T15:27:33Z