topic Re: Intervalmatch and Link Table? in QlikView

Intervalmatch and Link Table?

Tue, 16 Sep 2014 18:17:09 GMT

Hello everyone!

I'm having difficulties with my data model and maybe someone can help! I have two fact tables:

1. Shipment lines: Has a date field, and transaction quantities

2. Pay Period Ending: Has an Ending Date, and a number of productive hours assigned.

I want to find out what the ratio of Sum([SHIPPED-QTY]) / Productive hours within a week.

To establish which PPE period a transaction is assigned to, I used an Intervalmatch. However I am now caught in a circular loop I do not know how to get rid of. After some researching, I think it has something to do with creating a Linktable?

Does anyone have any ideas? I've attached a .qvd

Thank you all in advance!

Re: Intervalmatch and Link Table?

Tue, 16 Sep 2014 18:19:43 GMT

To further clarify:

Shipdate is used in WHSHIPLINE to find out which PPE_Period each transaction is in.

There are multiple COMPANYs that have different XXX_Hours values as well as transaction lines...

Re: Intervalmatch and Link Table?

Tue, 16 Sep 2014 20:15:45 GMT

I may be onto something... using a Join to "flatten" out the data model, and remove the intervalmatch table...