topic First Sorted Value in QlikView

First Sorted Value

Mon, 06 Oct 2014 09:59:50 GMT

Hi All,

I have data, say for example the following fields:

Client ID

Date of Purchase (This is a time stamp with also hour, mins and seconds)

anbu1984 — Mon, 06 Oct 2014 10:04:04 GMT

Load ClientID,

FirstSortedValue(DateofPurchase ,-DateofPurchase ) As DateofPurchase ,

FirstSortedValue(Category,-DateofPurchase ) As Category,

FirstSortedValue(Store ,-DateofPurchase ) As Store,

FirstSortedValue(Region,-DateofPurchase ) As Region

Group by ClientID;

Load ClientID, Timestamp#(DateofPurchase,'M/D/YYYY hh:mm:ss') As DateofPurchase ,Category,Store ,Region

From Table

Mon, 06 Oct 2014 10:57:27 GMT

Thank you Anbu