topic Hide the record with lower extractdate for a given srccode , region, material combination in QlikView

Hide the record with lower extractdate for a given srccode , region, material combination

parul_mehta — Wed, 25 Nov 2020 16:16:04 GMT

In the below data

There are currently 7 records

I want to hide the record with the lower extract date , for a given Material / srcsyscd, region combination

For example, from the first two records that belong to PKS-NSP , USA and CMC11, I want to hide the first row with the date 22/06/2017

and display only the row with the higher extract date 01072017

devarasu07 — Thu, 17 Aug 2017 06:48:05 GMT

Hi,

Can you share your sample app, Thanks

also you may try like below 3 methods

1) max(extractdate) as your expression

2) Aggr(max(extractdate),Material,srcsyscd, region)

3) =FirstSortedValue(srcsyscd, -extractdate)

4) back end script method,

like below,

Load *,

Date(Max(extractdate),'mm/dd/yyyy') as Date

FROM FileName

GROUP BY Material,srcsyscd, region;

Hope this helps to you

Thanks,

Deva