Join tables multiple times

[Margaret]

Is it possible to join two Qlikview Tables multiple times?

I have a table with Hospital visits with various things that happen over the course of a visit. Often different Providers (Doctor, Nurse Practitioner, etc.) are associated with different aspects of the same visit. Can I join to the Hospitalist table multiple times? If so, how?

[boorgura]

Can you please share a sample of expected output data format?

Or do you expect the result to have multiple columns - like DS_Name, HP_Name, AD_Name

[alexpanjhc]

instead of joining many times (which I do not know what that means), I would create different tables like Hospotalists that joins different fields in the HospitalMedcine table. That will make it a preferable model for Qlikview. However, no one knows your data better than yourself. This is only my 2 cents if that makes sense.

[Margaret]

I want to be able to create sheet objects using the Hospitalist's (full)Name (not the abbreviated ID which is used in the DS_Dictator field and the other fields in Hospital Medicine that have red lines drawn next to them) that show the work that a specific Hospitalist does, without having to click on that person in multiple listboxes. That is, I don't want to have to filter more than once to see the work of one hospitalist. I also want to filter by GroupName, which I can't do unless I link to the Hospitalists table which contains GroupNames.

For example, I want to create a sheet with

1. a line graph showing percentage of Discharge Summaries dictated on or before the date of discharge over time
2. a line graph showing percentage of patients for whom an Advance Directive was ordered over time
3. a single listbox where a user can select one or more Hospitalist(s) that will make both above referenced line graphs display the data for only that/those Hospitalist(s)

[Margaret]

Maybe I should have specified that when I said joining multiple times, I meant I want those red lines I drew in the image to be joins in QlikView.

Are you saying I should write the script so that the Table Viewer shows multiple instances of the Hospitalist table, each joined once to the HospitalMedicine table? I considered this, but it sounds cumbersome and it prevents me from doing what I describe in my response to boorgura, above--I think.

[rwunderlich · Accepted solution]

I would create a link table between the two tables that would associate a VistiID with multiple ProdivderIds.

Example attached.

-Rob

[boorgura]

Let me ask you this:

you one row (or one record) always have only 1 ID populated? If more than 1 is populated, will all of them be the same?

[Margaret]

One Visit Record in the HospitalMedicine Table will have more than one ProviderID, and those ProviderID's may be different (because different providers are associated with different aspects of the same visit).

[Margaret]

Hi, Rob. I read up on Link Tables, but I can't figure out what you mean. Could you please explain? I really appreciate your help.

[rwunderlich]

I've attached an example in my reply above. Download it and see if it makes sense to you.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com