Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Check the "IntervalMatch()" instruction then add a "Where" to filter data between this two dates
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);