Pivot Display row with latest date from range

Jonathan_Alm — Fri, 23 May 2014 07:14:17 GMT

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

Re: Pivot Display row with latest date from range

tresB — Fri, 23 May 2014 07:27:54 GMT

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

PFA

Re: Pivot Display row with latest date from range

Jonathan_Alm — Mon, 02 Jun 2014 13:33:00 GMT

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

topic Re: Pivot Display row with latest date from range in QlikView

Pivot Display row with latest date from range

Re: Pivot Display row with latest date from range

Re: Pivot Display row with latest date from range