Solved: Finding latest score in qlik function - Qlik Community

kishorj1982 · ‎2018-11-13

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

PrashantSangle · ‎2018-11-14

try with firstsortedvalue()

see below link

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunctio...

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

kishorj1982 · ‎2018-11-14

Hi All,

Could you please suggest on this.

Thanks

PrashantSangle · ‎2018-11-14

try with firstsortedvalue()

see below link

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunctio...

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

kishorj1982 · ‎2018-11-14

Hi All,

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

Thanks

kishorj1982 · ‎2018-11-14

Hi All,

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

I have attached highlighted part in an attachment.

Thanks