Skip to main content

Water Cooler

This space is for everyone to ask questions related to the Community Platform. It's a space for us to get to know each other and have some fun! Come in and gather around the Water Cooler!

Announcements
Have an amazing Qlik Success Story? Share it at QlikWorld! Submit Your Story
cancel
Showing results for 
Search instead for 
Did you mean: 
kishorj1982
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
shiveshsingh
Master
Master

Please use below expression

 

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

 

Capture.PNG

View solution in original post

4 Replies
shiveshsingh
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?

 

kishorj1982
Creator II
Creator II
Author

Yes, requirement is like that.

Thanks

kishorj1982
Creator II
Creator II
Author

@tresesco could you please suggest on this.

shiveshsingh
Master
Master

Please use below expression

 

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

 

Capture.PNG