Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
nicolai_moller
New 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

Re: Return dates older than a specific date

Please see the attached file.

View solution in original post

1 Reply

Re: Return dates older than a specific date

Please see the attached file.

View solution in original post