https://community.qlik.com/t5/Management-Governance/Using-distinct-in-expression/m-p/2000096#M23646 <P>Hello everyone, I needed to create an expression using if and maketime, but I am not able to apply DISTINCT in count. How would you proceed in that case?</P> <LI-CODE lang="markup">=count( if((DT_LOS_PROC -DT_PRESC)&lt;=MakeTime(0,30), %PRIMAY_CLIENTS) )</LI-CODE> <P>&nbsp;</P> Thu, 03 Nov 2022 12:05:34 GMT lucasx15 2022-11-03T12:05:34Z https://community.qlik.com/t5/Management-Governance/Using-distinct-in-expression/m-p/2000096#M23646 <P>Hello everyone, I needed to create an expression using if and maketime, but I am not able to apply DISTINCT in count. How would you proceed in that case?</P> <LI-CODE lang="markup">=count( if((DT_LOS_PROC -DT_PRESC)&lt;=MakeTime(0,30), %PRIMAY_CLIENTS) )</LI-CODE> <P>&nbsp;</P> Thu, 03 Nov 2022 12:05:34 GMT https://community.qlik.com/t5/Management-Governance/Using-distinct-in-expression/m-p/2000096#M23646 lucasx15 2022-11-03T12:05:34Z https://community.qlik.com/t5/Management-Governance/Using-distinct-in-expression/m-p/2000102#M23648 <P>Hi, have you tried?</P> <LI-CODE lang="markup">=count(Distinct if((DT_LOS_PROC -DT_PRESC)&lt;=MakeTime(0,30), %PRIMAY_CLIENTS) )</LI-CODE> Thu, 03 Nov 2022 12:17:55 GMT https://community.qlik.com/t5/Management-Governance/Using-distinct-in-expression/m-p/2000102#M23648 rubenmarin 2022-11-03T12:17:55Z https://community.qlik.com/t5/Management-Governance/Using-distinct-in-expression/m-p/2000721#M23658 <P>Thank you very much! I hadn't posted that, thanks!!!</P> Fri, 04 Nov 2022 13:59:27 GMT https://community.qlik.com/t5/Management-Governance/Using-distinct-in-expression/m-p/2000721#M23658 lucasx15 2022-11-04T13:59:27Z