Data model loop issue

Fri, 19 Dec 2014 13:53:31 GMT

I have a "loop" issue with my data load in qlikView

I don't know how to tackle this. It seem that the problem is that we can go to test from center by these two paths:

Center->patient->test and

from Center->role->user->test

I don't want to remove a link because If i remove the patient center link, I could not see the center of patients that dont have tests

and if I remove the center->user (by role) link, I could not see the center of users that does'nt have do tests.

What can I do for this ?

Re: Data model loop issue

Michiel_QV_Fan — Fri, 19 Dec 2014 13:55:16 GMT

Load the field ID_PATIENT again but rename it to something else, for instance ID_PATIENT _KEY in all tables.

ID_PATIENT as ID_PATIENT _KEY