Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I would create a link table between the two tables that would associate a VistiID with multiple ProdivderIds.
Example attached.
-Rob
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
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.
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
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.
I would create a link table between the two tables that would associate a VistiID with multiple ProdivderIds.
Example attached.
-Rob
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?
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).
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.
I've attached an example in my reply above. Download it and see if it makes sense to you.
-Rob