topic Re: Finding first OrderDate by customer name in QlikView https://community.qlik.com/t5/QlikView/Finding-first-OrderDate-by-customer-name/m-p/127519#M765247 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P>Dimension</P><P><STRONG>Customer</STRONG></P><P></P><P>Expression</P><P><STRONG>Date(Min(OrderDate))</STRONG></P></BODY></HTML> Tue, 10 Jul 2018 16:31:33 GMT sunny_talwar 2018-07-10T16:31:33Z Finding first OrderDate by customer name https://community.qlik.com/t5/QlikView/Finding-first-OrderDate-by-customer-name/m-p/127518#M765246 <HTML><HEAD></HEAD><BODY><P>HI All </P><P></P><P>I want to fetch first order date from the list customer name.</P><P></P><P>Here is the data--</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="162"><TBODY><TR><TD height="20" width="73">Customers</TD><TD width="89">OrderDate</TD></TR><TR><TD height="20">A</TD><TD>21/01/2016</TD></TR><TR><TD height="20">A</TD><TD>21/01/2017</TD></TR><TR><TD height="20">A</TD><TD>21/01/2018</TD></TR><TR><TD height="20">A</TD><TD>21/01/2019</TD></TR><TR><TD height="20">A</TD><TD>21/01/2020</TD></TR><TR><TD height="20">B</TD><TD>22/02/2016</TD></TR><TR><TD height="20">B</TD><TD>22/02/2017</TD></TR><TR><TD height="20">B</TD><TD>22/02/2018</TD></TR><TR><TD height="20">B</TD><TD>22/02/2019</TD></TR><TR><TD height="20">B</TD><TD>22/02/2020</TD></TR><TR><TD height="20">C</TD><TD>23/03/2016</TD></TR><TR><TD height="20">C</TD><TD>23/03/2017</TD></TR><TR><TD height="20">C</TD><TD>23/03/2018</TD></TR><TR><TD height="20">C</TD><TD>23/03/2019</TD></TR><TR><TD height="20">C</TD><TD><P>23/03/2020</P></TD></TR></TBODY></TABLE><P></P><P>Ans i am looking is--</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 162px;"><TBODY><TR><TD height="20" width="73">Customers</TD><TD width="89">OrderDate</TD></TR><TR><TD height="20">A</TD><TD>21/01/2016</TD></TR><TR><TD height="20">B</TD><TD>22/02/2016</TD></TR><TR><TD height="20">C</TD><TD>23/03/2016</TD></TR><TR><TD height="20"></TD><TD height="20"></TD><TD></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Finding-first-OrderDate-by-customer-name/m-p/127518#M765246 Santosh 2020-11-25T16:16:04Z Re: Finding first OrderDate by customer name https://community.qlik.com/t5/QlikView/Finding-first-OrderDate-by-customer-name/m-p/127519#M765247 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P>Dimension</P><P><STRONG>Customer</STRONG></P><P></P><P>Expression</P><P><STRONG>Date(Min(OrderDate))</STRONG></P></BODY></HTML> Tue, 10 Jul 2018 16:31:33 GMT https://community.qlik.com/t5/QlikView/Finding-first-OrderDate-by-customer-name/m-p/127519#M765247 sunny_talwar 2018-07-10T16:31:33Z Re: Finding first OrderDate by customer name https://community.qlik.com/t5/QlikView/Finding-first-OrderDate-by-customer-name/m-p/127520#M765248 <HTML><HEAD></HEAD><BODY><P>Or in the load script</P><P></P><P><STRONG>MinDate:</STRONG></P><P><STRONG>LOAD Customer,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; Date(Min(OrderDate)) as MinOrderDate</STRONG></P><P><STRONG>Resident ....</STRONG></P><P><STRONG>Group By Customer;</STRONG></P></BODY></HTML> Tue, 10 Jul 2018 16:32:10 GMT https://community.qlik.com/t5/QlikView/Finding-first-OrderDate-by-customer-name/m-p/127520#M765248 sunny_talwar 2018-07-10T16:32:10Z Re: Finding first OrderDate by customer name https://community.qlik.com/t5/QlikView/Finding-first-OrderDate-by-customer-name/m-p/127521#M765249 <HTML><HEAD></HEAD><BODY><P>Not working..it show like this.</P><P></P><P><IMG alt="snip.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/207488_snip.JPG" style="height: auto;" /></P></BODY></HTML> Tue, 10 Jul 2018 17:56:55 GMT https://community.qlik.com/t5/QlikView/Finding-first-OrderDate-by-customer-name/m-p/127521#M765249 Santosh 2018-07-10T17:56:55Z Re: Finding first OrderDate by customer name https://community.qlik.com/t5/QlikView/Finding-first-OrderDate-by-customer-name/m-p/127522#M765250 <HTML><HEAD></HEAD><BODY><P>Is your Date field read as date by qlik sense?</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/2954">Why don’t my dates work?</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A></P><P><A href="https://community.qlik.com/docs/DOC-3102">QlikView Date fields</A></P></BODY></HTML> Tue, 10 Jul 2018 17:58:26 GMT https://community.qlik.com/t5/QlikView/Finding-first-OrderDate-by-customer-name/m-p/127522#M765250 sunny_talwar 2018-07-10T17:58:26Z