Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.
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

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.
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
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