Discussion board where members can get started with QlikView.
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.
try with firstsortedvalue()
see below link
View solution in original post
Could you please suggest on this.
I am unable to get how to get MTD in above function.
Could you please suggest on this. My output must be as per attachment.
I have attached highlighted part in an attachment.