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?

[MarcoWedel]

Hi,

to create a link table between your HospitalMedicine and Hospitalists table, you could also try with:

tabLink:
Crosstable (Role, HospID)
LOAD VisitID,
          DS_Dictator,
          HP_Dictator,
          AD_Orderer,
          Dis_Biller,
          FUBiller
Resident HospitalMedicine;

Also change the DS_Dictator field name of your Hospitals table to "HospID".

Hope this helps

regards

Marco

[Margaret]

So it sounds like the literal answer to my question is "no"--you can't join tables in QlikView more than once?

Or you can, but it's a bad idea because...?

[MarcoWedel]

Yes, you can load the same Hospitalists table multiple times using different (role specific) table and field names.

Your specified function to be able to click on one person to see all corresponding visits regardless of the hospitalist role suggests another solution though. That's why you received solutions that implement your requirement.

Please close your thread, if your question is answered.

thanks

regards

Marco