topic Re: Count of dataes in QlikView https://community.qlik.com/t5/QlikView/Count-of-dataes/m-p/1253713#M872445 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.qlik.com/qlik-users/2454">sunny</A></P><P></P><P>Ya...get count only if it has date between PlanDate and StartDate.</P><P></P><P>For Ex: ID 2 doesnt have a PlanDate ...so it doesn't count...</P><P></P><P></P><P>Thanks much</P></BODY></HTML> Tue, 15 Nov 2016 18:25:54 GMT apthansh 2016-11-15T18:25:54Z Count of dataes https://community.qlik.com/t5/QlikView/Count-of-dataes/m-p/1253711#M872443 <HTML><HEAD></HEAD><BODY><P>I have table as below.Here PlanDate,EndDate,StartDate,StartEndDate are different phases.....</P><P></P><P>ID&nbsp;&nbsp;&nbsp;&nbsp; PlanDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EndDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; StartDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; StartEndDate</P><P></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10/06/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10/08/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11/05/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11/19/2016</P><P>2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10/10/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10/20/2016</P><P></P><P></P><P></P><P>Here I have to get the count of ID only if it has date between PlanDate and StartDate&nbsp; has.</P><P>So based on the above example I should Only get count of 1.How can I do that ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Count-of-dataes/m-p/1253711#M872443 apthansh 2020-11-25T16:16:04Z Re: Count of dataes https://community.qlik.com/t5/QlikView/Count-of-dataes/m-p/1253712#M872444 <HTML><HEAD></HEAD><BODY><P>It has date between PlanDate and StartDate? Can you elaborate a little bit?</P></BODY></HTML> Tue, 15 Nov 2016 17:26:55 GMT https://community.qlik.com/t5/QlikView/Count-of-dataes/m-p/1253712#M872444 sunny_talwar 2016-11-15T17:26:55Z Re: Count of dataes https://community.qlik.com/t5/QlikView/Count-of-dataes/m-p/1253713#M872445 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.qlik.com/qlik-users/2454">sunny</A></P><P></P><P>Ya...get count only if it has date between PlanDate and StartDate.</P><P></P><P>For Ex: ID 2 doesnt have a PlanDate ...so it doesn't count...</P><P></P><P></P><P>Thanks much</P></BODY></HTML> Tue, 15 Nov 2016 18:25:54 GMT https://community.qlik.com/t5/QlikView/Count-of-dataes/m-p/1253713#M872445 apthansh 2016-11-15T18:25:54Z Re: Count of dataes https://community.qlik.com/t5/QlikView/Count-of-dataes/m-p/1253714#M872446 <HTML><HEAD></HEAD><BODY><P>so you want to only count <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IDs that do not have a PlanDate?</SPAN></P></BODY></HTML> Tue, 15 Nov 2016 22:05:23 GMT https://community.qlik.com/t5/QlikView/Count-of-dataes/m-p/1253714#M872446 MarcoWedel 2016-11-15T22:05:23Z