Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Finding latest score in qlik function

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
Highlighted
Creator II
Creator II

Re: Finding latest score in qlik function

Hi All,

 

Could you please suggest on this.

 

Thanks

Highlighted

Re: Finding latest score in qlik function

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

Highlighted
Creator II
Creator II

Re: Finding latest score in qlik function

Hi All,

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

Thanks

Highlighted
Creator II
Creator II

Re: Finding latest score in qlik function

Hi All,

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

I have attached highlighted part in an attachment.

 

Thanks