topic Re: New Clients in QlikView https://community.qlik.com/t5/QlikView/New-Clients/m-p/673354#M1081354 <HTML><HEAD></HEAD><BODY><P>If i try min[Start Date] as [min date] it say to me that it is invalid expression</P></BODY></HTML> Sat, 28 Jun 2014 18:19:45 GMT 2014-06-28T18:19:45Z New Clients https://community.qlik.com/t5/QlikView/New-Clients/m-p/673351#M1081351 <HTML><HEAD></HEAD><BODY><P>I need to display only new clients for a certain period, for example for 2014, or for 1 month only. Please help me.</P></BODY></HTML> Sat, 28 Jun 2014 17:29:39 GMT https://community.qlik.com/t5/QlikView/New-Clients/m-p/673351#M1081351 2014-06-28T17:29:39Z Re: New Clients https://community.qlik.com/t5/QlikView/New-Clients/m-p/673352#M1081352 <HTML><HEAD></HEAD><BODY><P>Create a Year in your script...</P><P></P><P>Year([Start Date]) as Year</P><P></P><P>Now use below in your table</P><P></P><P>COUNT{&lt;Year = {'$(=Year(Today()))'}&gt;}Distinct UserNS)</P></BODY></HTML> Sat, 28 Jun 2014 17:43:28 GMT https://community.qlik.com/t5/QlikView/New-Clients/m-p/673352#M1081352 MK_QSL 2014-06-28T17:43:28Z Re: New Clients https://community.qlik.com/t5/QlikView/New-Clients/m-p/673353#M1081353 <HTML><HEAD></HEAD><BODY><P>Create one Master Calender&nbsp; table using the min/max start dates and join that to main table.</P><P></P><P>Count(Distinct{&lt;CLNDR_YR={'$(=Year([Start Date]))'}&gt;}UserNS)</P><P></P><P></P><P>Regards</P><P>Pradeep</P></BODY></HTML> Sat, 28 Jun 2014 17:51:02 GMT https://community.qlik.com/t5/QlikView/New-Clients/m-p/673353#M1081353 PradeepReddy 2014-06-28T17:51:02Z Re: New Clients https://community.qlik.com/t5/QlikView/New-Clients/m-p/673354#M1081354 <HTML><HEAD></HEAD><BODY><P>If i try min[Start Date] as [min date] it say to me that it is invalid expression</P></BODY></HTML> Sat, 28 Jun 2014 18:19:45 GMT https://community.qlik.com/t5/QlikView/New-Clients/m-p/673354#M1081354 2014-06-28T18:19:45Z Re: New Clients https://community.qlik.com/t5/QlikView/New-Clients/m-p/673355#M1081356 <HTML><HEAD></HEAD><BODY><P>And how i do it for a period? I work only for present year.</P></BODY></HTML> Sat, 28 Jun 2014 18:20:29 GMT https://community.qlik.com/t5/QlikView/New-Clients/m-p/673355#M1081356 2014-06-28T18:20:29Z