Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
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.

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

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

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

Try this thread for inspiration: