topic Re: Multiple IDs to one ID in QlikView

Multiple IDs to one ID

Mon, 07 Mar 2016 14:20:38 GMT

Hi all.

I'm stuck with an issue when trying to produce dashboards for Easyvista Service Manager data. I have various tables with ID fields that are linked to one table with the main ID and all the information linked with it like Name, Department... If I load all the fields I end up with synthetic keys and circular references. Qlikview is getting nuts when refreshing my charts

For example, table SD_REQUEST has RECIPIENT_ID, REQUESTOR_ID and OWNER_ID columns that are pointing towards the EMPLOYEE_ID column of the AM_EMPLOYEE table.

I looked for information in the community forums as well as on the web using Google but cannot find a way to handle that correctly. I explored various options but cannot seem to find the one that would fit the purpose. Before investing too much time I would like to make sure I choose the right approach.

Is the link table the way to go?

Best regards.

Re: Multiple IDs to one ID

alexandros17 — Mon, 07 Mar 2016 16:43:18 GMT

Could you share your app? I think that data model must be re engineered.

Re: Multiple IDs to one ID

Mon, 07 Mar 2016 16:47:29 GMT

Hi, I am not sure if this helps as maybe I am not getting the full understanding of what you need. I had a similar problem with multiple files having an employee ID etc. What I did was on load of the various files I then used the "Join" function to create a separate master table with all the parsed data.

Does this make sense?

Regards

Roberto