topic Re: Count number of cases that happens once in a period in QlikView https://community.qlik.com/t5/QlikView/Count-number-of-cases-that-happens-once-in-a-period/m-p/1202762#M462244 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>Count({&lt;ID = {"=Count(ID) = 1"}&gt;}ID)</STRONG></P></BODY></HTML> Wed, 05 Oct 2016 11:51:28 GMT sunny_talwar 2016-10-05T11:51:28Z Count number of cases that happens once in a period https://community.qlik.com/t5/QlikView/Count-number-of-cases-that-happens-once-in-a-period/m-p/1202761#M462243 <HTML><HEAD></HEAD><BODY><P>Hi guys, </P><P></P><P>I'm facing an issue to find a expression that counts the number of ID's that happens only once in a period of days. </P><P></P><P>Example: in the last 15 days I have the following ID's appearing in a log file:</P><P></P><P>X</P><P>Y</P><P>Z</P><P>W</P><P>Y</P><P>K</P><P>Z</P><P></P><P>I can see that Y and Z appeared more than once in this period, so I need an expression that will give me the result equal to 3 (that is the number of IDs that only appeared once in this interval = X, W and K). Any ideas?</P><P></P><P>Thankss!</P></BODY></HTML> Wed, 05 Oct 2016 11:45:14 GMT https://community.qlik.com/t5/QlikView/Count-number-of-cases-that-happens-once-in-a-period/m-p/1202761#M462243 2016-10-05T11:45:14Z Re: Count number of cases that happens once in a period https://community.qlik.com/t5/QlikView/Count-number-of-cases-that-happens-once-in-a-period/m-p/1202762#M462244 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>Count({&lt;ID = {"=Count(ID) = 1"}&gt;}ID)</STRONG></P></BODY></HTML> Wed, 05 Oct 2016 11:51:28 GMT https://community.qlik.com/t5/QlikView/Count-number-of-cases-that-happens-once-in-a-period/m-p/1202762#M462244 sunny_talwar 2016-10-05T11:51:28Z