* How to get second date for each trade id **

Mon, 06 Jan 2014 15:03:53 GMT

hi all,

PFA excel sample data.

from this data i need to form 2 fields

Field1 --> 2nd date from DAte1 column by each trade id

Field 2 --> 2nd date from last in Date2 Column by each trade id

I tried many way but facing prob.

Please suggest me some way to get it done ASAP.

Thanks

Re: * How to get second date for each trade id **

Nicole-Smith — Mon, 06 Jan 2014 15:16:13 GMT

See the attached for full example:

Data:

LOAD tradeid,

     date1,

     date2

FROM

[data sample.xlsx]

(ooxml, embedded labels, table is Sheet1);

left join (Data)

LOAD tradeid,

     date(FirstSortedValue(date1, date1, 2)) as Field1,

     date(FirstSortedValue(date2, -date2, 2)) as Field2

RESIDENT Data

Group by tradeid;

topic *** How to get second date for each trade id **** in QlikView

*** How to get second date for each trade id ****

Re: *** How to get second date for each trade id ****

topic * How to get second date for each trade id ** in QlikView

* How to get second date for each trade id **

Re: * How to get second date for each trade id **