topic How to count same value only one time? in QlikView https://community.qlik.com/t5/QlikView/How-to-count-same-value-only-one-time/m-p/275467#M1178462 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have a table with decision and subdecision. Each subdecision are connected to the main decision by a decisionID. I want to count the decisionID but only ones. So, what function do I use to only count uniq IDs?</P><P><STRONG> </STRONG></P><P><STRONG>551</STRONG> </P><P>552</P><P>553</P><P><STRONG>551 </STRONG></P><P></P><P>as only 3 posts? </P><P></P><P></P><P>/Thanks!</P></BODY></HTML> Mon, 13 Feb 2012 10:04:16 GMT 2012-02-13T10:04:16Z How to count same value only one time? https://community.qlik.com/t5/QlikView/How-to-count-same-value-only-one-time/m-p/275467#M1178462 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have a table with decision and subdecision. Each subdecision are connected to the main decision by a decisionID. I want to count the decisionID but only ones. So, what function do I use to only count uniq IDs?</P><P><STRONG> </STRONG></P><P><STRONG>551</STRONG> </P><P>552</P><P>553</P><P><STRONG>551 </STRONG></P><P></P><P>as only 3 posts? </P><P></P><P></P><P>/Thanks!</P></BODY></HTML> Mon, 13 Feb 2012 10:04:16 GMT https://community.qlik.com/t5/QlikView/How-to-count-same-value-only-one-time/m-p/275467#M1178462 2012-02-13T10:04:16Z How to count same value only one time? https://community.qlik.com/t5/QlikView/How-to-count-same-value-only-one-time/m-p/275468#M1178463 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Use Count(Distinct DecisionID).</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Distinct keyword selects only unique data.</P><P>Celambarasan</P></BODY></HTML> Mon, 13 Feb 2012 10:10:41 GMT https://community.qlik.com/t5/QlikView/How-to-count-same-value-only-one-time/m-p/275468#M1178463 CELAMBARASAN 2012-02-13T10:10:41Z How to count same value only one time? https://community.qlik.com/t5/QlikView/How-to-count-same-value-only-one-time/m-p/275469#M1178464 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try using the Distinct option in Count()</P><P></P><P>=Count(Distinct DecisionID)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 13 Feb 2012 10:50:47 GMT https://community.qlik.com/t5/QlikView/How-to-count-same-value-only-one-time/m-p/275469#M1178464 jagan 2012-02-13T10:50:47Z