Loading data between date range

[#1]

Hello everyone,

I have a file which contains an customer ID, their application date, as well as the implementation date (format is MM-DD-YYYY).

It looks something like the following:

customer ID     Order Application Date      Order Implementation Date

1                    1/1/2000                           1/14/2000

2                    1/6/2000                           1/20/2000

...

etc

Customers may change orders and we keep track of the changes by logging an interaction with notes each time customer made changes.

How do I specify in Qlikview to load only the interactions made by the customers between the order application date and implementation date? I know which fields to load, but I am not sure how to define the "date range" for each row loaded

Thanks in advance

Since this is for analysis and practice only, we are only looking at the OLDEST order applied by each customer,so the first table will contain unique customer ID (the real table doesn't though), each with only 1 application order, which is the FIRST order put by the customer

[vivientexier]

Hello,

Check the "IntervalMatch()" instruction then add a "Where" to filter data between this two dates

[sujeetsingh]

Hi,

just write a conditional flag as :

if(DateofOrder<OrderInplementation and DateofOrder>OrderApplication,1,0) as CustomerIncludeFlag

Now derive the table in another table by resident load and then write condition

Table2:

Load field1,field2,field3.....

resident Table1 where (CustomerIncludeFlag<>0);