Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kishorj1982
Creator II
Creator II

Finding latest score in qlik function

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

 

1 Solution

Accepted Solutions
PrashantSangle

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.

View solution in original post

4 Replies
kishorj1982
Creator II
Creator II
Author

Hi All,

 

Could you please suggest on this.

 

Thanks

PrashantSangle

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.
kishorj1982
Creator II
Creator II
Author

Hi All,

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

Thanks

kishorj1982
Creator II
Creator II
Author

Hi All,

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

I have attached highlighted part in an attachment.

 

Thanks