topic Count without duplicate based on value in App Development https://community.qlik.com/t5/App-Development/Count-without-duplicate-based-on-value/m-p/2129924#M91877 <P>hello,</P> <P>I am trying to create application that count ID number based on different services, the idea is to count the ID for each service but without duplicate if they were under same project otherwise count all IDs, also if the ID have 2nd round in different project to count it as new ID example below:&nbsp;</P> <TABLE width="510"> <TBODY> <TR> <TD width="64">ID</TD> <TD width="111">project</TD> <TD width="118">type of service</TD> <TD width="105">first round</TD> <TD width="112">second round</TD> </TR> <TR> <TD>1</TD> <TD>AA</TD> <TD>C</TD> <TD>yes</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>1</TD> <TD>BB</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>yes</TD> </TR> <TR> <TD>2</TD> <TD>BB</TD> <TD>C</TD> <TD>yes</TD> <TD>yes</TD> </TR> <TR> <TD>3</TD> <TD>BB</TD> <TD>C</TD> <TD>yes</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>4</TD> <TD>AA</TD> <TD>C</TD> <TD>yes</TD> <TD>yes</TD> </TR> <TR> <TD>5</TD> <TD>AA</TD> <TD>C</TD> <TD>yes</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>6</TD> <TD>BB</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>6</TD> <TD>BB</TD> <TD>C</TD> <TD>yes</TD> <TD>yes</TD> </TR> <TR> <TD>7</TD> <TD>AA</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>8</TD> <TD>AA</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>9</TD> <TD>BB</TD> <TD>N</TD> <TD>yes</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>10</TD> <TD>AA</TD> <TD>C</TD> <TD>yes</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>10</TD> <TD>AA</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>yes</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>any idea about how the formula will be?&nbsp;</P> Fri, 15 Nov 2024 21:19:16 GMT Nancy_sh 2024-11-15T21:19:16Z Count without duplicate based on value https://community.qlik.com/t5/App-Development/Count-without-duplicate-based-on-value/m-p/2129924#M91877 <P>hello,</P> <P>I am trying to create application that count ID number based on different services, the idea is to count the ID for each service but without duplicate if they were under same project otherwise count all IDs, also if the ID have 2nd round in different project to count it as new ID example below:&nbsp;</P> <TABLE width="510"> <TBODY> <TR> <TD width="64">ID</TD> <TD width="111">project</TD> <TD width="118">type of service</TD> <TD width="105">first round</TD> <TD width="112">second round</TD> </TR> <TR> <TD>1</TD> <TD>AA</TD> <TD>C</TD> <TD>yes</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>1</TD> <TD>BB</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>yes</TD> </TR> <TR> <TD>2</TD> <TD>BB</TD> <TD>C</TD> <TD>yes</TD> <TD>yes</TD> </TR> <TR> <TD>3</TD> <TD>BB</TD> <TD>C</TD> <TD>yes</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>4</TD> <TD>AA</TD> <TD>C</TD> <TD>yes</TD> <TD>yes</TD> </TR> <TR> <TD>5</TD> <TD>AA</TD> <TD>C</TD> <TD>yes</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>6</TD> <TD>BB</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>6</TD> <TD>BB</TD> <TD>C</TD> <TD>yes</TD> <TD>yes</TD> </TR> <TR> <TD>7</TD> <TD>AA</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>8</TD> <TD>AA</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>9</TD> <TD>BB</TD> <TD>N</TD> <TD>yes</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>10</TD> <TD>AA</TD> <TD>C</TD> <TD>yes</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>10</TD> <TD>AA</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>yes</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>any idea about how the formula will be?&nbsp;</P> Fri, 15 Nov 2024 21:19:16 GMT https://community.qlik.com/t5/App-Development/Count-without-duplicate-based-on-value/m-p/2129924#M91877 Nancy_sh 2024-11-15T21:19:16Z