topic Re: Count Missing ID in QlikView https://community.qlik.com/t5/QlikView/Count-Missing-ID/m-p/1306483#M1250594 <HTML><HEAD></HEAD><BODY><P>If possible please share the sample data which can be used to produced the required expression easily.</P></BODY></HTML> Mon, 22 May 2017 13:02:20 GMT Digvijay_Singh 2017-05-22T13:02:20Z Count Missing ID https://community.qlik.com/t5/QlikView/Count-Missing-ID/m-p/1306482#M1250591 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I am facing difficulty in building the logic mentioned below:</P><P>If a ID was activated and never deactivated till Today then consider it as active for all Months.</P><P></P><P>Input:</P><P><IMG alt="Input.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164213_Input.png" style="height: auto;" /></P><P></P><P>output:</P><P><IMG alt="Input.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/164214_Input.png" style="height: auto;" /></P><P>In the above output:</P><P>Jul 2012 had 2 IDs 1 and 2 ,therefore&nbsp; Count(ID)=2</P><P>Aug 2012 have only one ID(i.e. 2).&nbsp; ID 1 <SPAN style="font-size: 13.3333px;">is not updated in Aug&nbsp; and also it </SPAN>is not deactivated in Jul 2012 .So,i have to count it as activate in Aug 2012 .</P><P></P><P>Thanks,</P><P>Pooja</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Count-Missing-ID/m-p/1306482#M1250591 pooja_prabhu_n 2026-01-26T18:19:17Z Re: Count Missing ID https://community.qlik.com/t5/QlikView/Count-Missing-ID/m-p/1306483#M1250594 <HTML><HEAD></HEAD><BODY><P>If possible please share the sample data which can be used to produced the required expression easily.</P></BODY></HTML> Mon, 22 May 2017 13:02:20 GMT https://community.qlik.com/t5/QlikView/Count-Missing-ID/m-p/1306483#M1250594 Digvijay_Singh 2017-05-22T13:02:20Z