topic Re: script reduce to max data only in QlikView

script reduce to max data only

userid128223 — Wed, 31 May 2017 20:19:04 GMT

I have file like attached. i need to select reduce data during script to max date.

Result will be:

2017-05-29 10:25:32:238

Chemistry

afd

neelamsaroha157 — Wed, 31 May 2017 20:54:16 GMT

Check this.

This will fetch you data for the max date.

Digvijay_Singh — Wed, 31 May 2017 21:04:16 GMT

Data:

Load

Timestamp(Max(Date)) as Date,

FirstSortedValue(Class,-Date) as Class,

FirstSortedValue(Grade,-Date) as Grade,

FirstSortedValue(Teacher,-Date) as Teacher,

FirstSortedValue(Notes,-Date) as Notes;

LOAD

Timestamp(Timestamp#(Date,'YYYY-MM-DD hh:mm:ss:fff'),'YYYY-MM-DD hh:mm:ss:fff') as Date,

Class,

Grade,

Teacher,

Notes

FROM

firstsortedValuedata.xlsx

(ooxml, embedded labels, table is Sheet1);