Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | |
May be try this
Dimension
Customer
Expression
Date(Min(OrderDate))
Or in the load script
MinDate:
LOAD Customer,
Date(Min(OrderDate)) as MinOrderDate
Resident ....
Group By Customer;
Not working..it show like this.
Is your Date field read as date by qlik sense?