Linking to Correct Temporal Data

Wed, 23 Nov 2011 15:42:56 GMT

Hi,

Can anyone help with with a small issue. I have an invoice table with invoice date and debt. I also have a full temporal table of account holder.

What I am trying to do is join the 2 tables together where the invoice date is between the effective_start and effective_end on the account holder table.

Any assistance would be greatfully received

Linking to Correct Temporal Data

Miguel_Angel_Baeyens — Wed, 23 Nov 2011 15:48:59 GMT

Hi Dave,

Check this thread in regards to the IntervalMatch() loading, that links a range table with a discrete value table.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

topic Linking to Correct Temporal Data in QlikView

Linking to Correct Temporal Data

Linking to Correct Temporal Data