Return dates older than a specific date

nicolai_moller — Wed, 29 Oct 2014 09:04:05 GMT

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 dates	Status
2014-03-03	completed
2014-09-09	completed
2014-10-10	waiting
2014-11-11	waiting

Any suggestions?

Re: Return dates older than a specific date

Kushal_Chawda — Wed, 29 Oct 2014 09:13:08 GMT

Please see the attached file.

topic Return dates older than a specific date in QlikView

Return dates older than a specific date

Re: Return dates older than a specific date