Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Margaret
Creator II
Creator II

Join tables multiple times

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?

Capture.PNG

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Example attached.

-Rob

View solution in original post

12 Replies
boorgura
Specialist
Specialist

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
Specialist
Specialist

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
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Example attached.

-Rob

boorgura
Specialist
Specialist

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
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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