Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Jonathan_Alm
Partner - Creator
Partner - Creator

Pivot Display row with latest date from range

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:

DateRange.png

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

PFA

View solution in original post

2 Replies
tresesco
MVP
MVP

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

PFA

Jonathan_Alm
Partner - Creator
Partner - Creator
Author

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