topic Data Model help in QlikView

Data Model help

leocattqv — Thu, 08 Jun 2017 15:53:26 GMT

Hi everyone,

I have been struggling with this for a bit and I am running out of ideas.

I have a need to link 2 tables together by Part Number. I also need a master calendar for these tables. How can I link them without creating a circular reference? picture of the data model is here.

Any direction would be appreciated.

thanks

-L

Re: Data Model help

el_aprendiz111 — Thu, 08 Jun 2017 16:33:31 GMT

Hi,

table Complaints: ID AS IDComplaints

Send me a sample of your data

Re: Data Model help

leocattqv — Thu, 08 Jun 2017 17:13:07 GMT

Here you go.

I need 2 link tables, Im just not sure how to do that without getting the circular reference

Re: Data Model help

Thu, 08 Jun 2017 17:54:23 GMT

Hi Leo,

The ID in your linktable, is it date ID or just unique key for your link table?, if there's no logical link between IDs between linktable and your complaints table, just liase one as Fer suggest.

Re: Data Model help

el_aprendiz111 — Thu, 08 Jun 2017 19:10:10 GMT

Hi,

TimeLinkTable:

load date(floor(Time)) as Date,

_Type,

ComplaintID AS _ComplaintID,

ShipID,

Time