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!

Highlighted
kishorj1982
Contributor 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

Tags (2)
1 Solution

Accepted Solutions
shiveshsingh
Honored Contributor

Re: Recent Value with MTD

Please use below expression

 

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

 

Capture.PNG

4 Replies
shiveshsingh
Honored Contributor

Re: Recent Value with MTD

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
Contributor II

Re: Recent Value with MTD

Yes, requirement is like that.

Thanks

kishorj1982
Contributor II

Re: Recent Value with MTD

@tresesco could you please suggest on this.

shiveshsingh
Honored Contributor

Re: Recent Value with MTD

Please use below expression

 

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

 

Capture.PNG