Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Return dates older than a specific date

Hi

I have created a field (table 1) that gives me the the latest completed date that is <= today from table 2. Table 1 actually contains many dates, but there is only one possible value for each customer.

I want to return all dates from table 2 that are greater than the possible value in table 1, so in this case it should be 2014-10-10 and 2014-11-11.

Table 1:

Date
2014-09-09

Table 2:

Other datesStatus
2014-03-03completed
2014-09-09completed
2014-10-10waiting
2014-11-11waiting

Any suggestions?

1 Solution

Accepted Solutions
MVP
MVP

Please see the attached file.

View solution in original post

1 Reply
MVP
MVP

Please see the attached file.

View solution in original post