Pivot Display row with latest date from range

[Jonathan_Alm]

Hi,

I am struggling with the following use case scenario. The user selects a range of dates using two variables vStartDate and vEndDate.

If two occurences with the same ID falls within this range, only the latest one should be displayed in the PIVOT. The other row should be removed.

The table looks like this:

As you can see, the user has selected a range from January 1st -> June 1st.

In this use case, ID 0101099 has an application made 2014-01-18 and also one on 2014-05-23. What I want is that only the latest application made should be displayed in the Pivot-table, all other rows should be "hidden/removed".

The same goes for ID 1004108.

I have also attached the qvw-example I am using.

Kind regards,

Jonathan

[tresesco · Accepted solution]

Take a straight table, expression: =If(Date=Aggr(NODISTINCT Max(Date),ID), Date)

PFA

[Jonathan_Alm]

Thanks for your response, I have verified the result and it works perfectly.