Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Recent Value with MTD

Hi All,

 

I want to  find the recent value (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 and I have highlighted the part that we need in output.

I tried with first sorted value but no luck.

Could you please suggest.

 

Thanks

1 Solution

Accepted Solutions
Highlighted
Master
Master

Please use below expression

 

FirstSortedValue([C Score],-[C Create Date])

 

Capture.PNG

View solution in original post

4 Replies
Highlighted
Master
Master

Hi

If i see your data, what do you mean by recent value? is it based on C Create Date?

If parent Id is 1, then recent child id will be C_1_5?

 

Highlighted
Creator II
Creator II

Yes, requirement is like that.

Thanks

Highlighted
Creator II
Creator II

@tresesco could you please suggest on this.

Highlighted
Master
Master

Please use below expression

 

FirstSortedValue([C Score],-[C Create Date])

 

Capture.PNG

View solution in original post