Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get the right data at any point of time?

Hello everybody,

I have different tables with start and end dates regarding to a productkey.

Table1:
Prodno, SellStartDate, SellEndDate
10001 01/01/2005 31/12/2099
10002 01/01/2005 31/12/2010

Table2:
Prodno, Desc, StartDate, EndDate
10001, xxx, 01/01/2005, 31/12/2005
10001, xxy, 01/01/2006, 31/12/2099
10002, ccc, 01/01/2005, 31/12/2010

Table3:
Prodno, Vendor, StartDate, EndDate
10001, 20020, 01/01/2005, 30/06/2006
10001, 20156, 01/07/2006, 31/12/2099

What is the best method, to get the right data at any point auf time? Is it possible to useeIntervalMatch with more than one table?

Thank you.

1 Reply
Not applicable
Author

Try this thread for inspiration:

http://community.qlik.com/forums/t/38067.aspx