Finding first OrderDate by customer name

[Santosh]

HI All

I want to fetch first order date from the list customer name.

Here is the data--

Customers	OrderDate
A	21/01/2016
A	21/01/2017
A	21/01/2018
A	21/01/2019
A	21/01/2020
B	22/02/2016
B	22/02/2017
B	22/02/2018
B	22/02/2019
B	22/02/2020
C	23/03/2016
C	23/03/2017
C	23/03/2018
C	23/03/2019
C	23/03/2020

Ans i am looking is--

Customers	OrderDate
A	21/01/2016
B	22/02/2016
C	23/03/2016

[sunny_talwar]

May be try this

Dimension

Customer

Expression

Date(Min(OrderDate))

[sunny_talwar]

Or in the load script

MinDate:

LOAD Customer,

     Date(Min(OrderDate)) as MinOrderDate

Resident ....

Group By Customer;

[Santosh]

Not working..it show like this.

[sunny_talwar]

Is your Date field read as date by qlik sense?

Why don’t my dates work?

Get the Dates Right

QlikView Date fields