topic Re: How to keep the latest value? in QlikView

How to keep the latest value?

pachi12 — Mon, 05 Sep 2022 16:21:36 GMT

Hi all,

I would need help from you.

In the below example, I would need to only keep the latest updated value (New Value = 2022-05-31T00:00:00.000Z) for the concerned Case number (1319).

To be noted that in my file I have >50000 different Case number.

I tried to find help on this forum however I am a bit lost (as not being an expert in this domain).

Thanks in advance for your help!

Pachi12

Re: How to keep the latest value?

Or — Mon, 05 Sep 2022 19:01:06 GMT

See e.g.

https://community.qlik.com/t5/QlikView-App-Dev/Select-first-row-of-a-grouped-dimension-in-load-script/td-p/754893

https://community.qlik.com/t5/QlikView-App-Dev/Load-only-first-record-per-ID/td-p/1264189

Re: How to keep the latest value?

BrunPierre — Mon, 05 Sep 2022 19:37:26 GMT

Try this one at UI

=MAX(AGGR(Count( DISTINCT CaseNumber ),UpdatedDate))

at the backend with this

Data: LOAD * Inline [ CaseNumber,Field_Details,NewValue,UpdatedDate 1319,Receiptdate,2005-02-20T00:00:00.000Z,06:03:2022 13:23:15 1319,Receiptdate,2022-05-31T00:00:00.000Z,06:08:2022 05:05:52 ]; NoConcatenate LOAD CaseNumber, Maxstring(Field_Details) as Field_Details, Max(NewValue) as NewValue, LastValue(UpdatedDate) as UpdatedDate Resident Data Group By CaseNumber Order By CaseNumber; DROP Table Data;

Re: How to keep the latest value?

pachi12 — Tue, 06 Sep 2022 11:24:06 GMT

Thanks a lot for your help!