topic Re: Date loading in QlikView

Date loading

Simon_BI — Thu, 21 Nov 2019 06:58:29 GMT

I need suggestion here.

Below i have six order lines, but i only want to have one order line with the earliest date as the output which means the output should be only one order line with 12/1/2019.

Could someone give a help here? Thanks

30234229, 3420, 12/1/2019, ACN

Order:
LOAD * INLINE [
ITEM, OrderQty, Date, Destination
30234229, 240, 12/31/2019, ACN
30234229, 3270, 12/13/2019, ACN
30234229, 3330, 12/7/2019, ACN
30234229, 3420, 12/1/2019, ACN
30234229, 3450, 12/6/2019, ACN
30234229, 3510, 12/20/2019, ACN
];

Re: Date loading

Anil_Babu_Samineni — Thu, 21 Nov 2019 07:25:51 GMT

Order:
LOAD ITEM, OrderQty, Date(Date#(Date,'MM/DD/YYYY')) as Date, Destination INLINE [
ITEM, OrderQty, Date, Destination
30234229, 240, 12/31/2019, ACN
30234229, 3270, 12/13/2019, ACN
30234229, 3330, 12/7/2019, ACN
30234229, 3420, 12/1/2019, ACN
30234229, 3450, 12/6/2019, ACN
30234229, 3510, 12/20/2019, ACN
];

Inner Join (Order)
LOAD ITEM, Min(Date) as Date Resident Order Group By ITEM;

Re: Date loading

Simon_BI — Thu, 21 Nov 2019 08:33:16 GMT

That works. Thank you so much Anil.