topic Finding latest score in qlik function in QlikView

Finding latest score in qlik function

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

Hi,

I want to find the latest score (on Child Id) for each Parent Id within a selected date range (e.g. MTD).

Could you please suggest how to proceed.

I have attached sample the data set for this.

Thanks,

Kishor

kishorj1982 — Wed, 14 Nov 2018 09:25:08 GMT

Hi All,

Could you please suggest on this.

Thanks

PrashantSangle — Wed, 14 Nov 2018 06:31:34 GMT

try with firstsortedvalue()

see below link

kishorj1982 — Wed, 14 Nov 2018 09:26:31 GMT

Hi All,

I am unable to get how to get MTD in above function.

Thanks

kishorj1982 — Wed, 14 Nov 2018 14:18:31 GMT

Hi All,

Could you please suggest on this. My output must be as per attachment.

I have attached highlighted part in an attachment.

Thanks