topic Linking problem in QlikView

Linking problem

Thu, 20 Jun 2013 13:28:44 GMT

I have a data model of 6 tables, joined by a common primary key,

in this 6 tables, 3 tables have Status, another 2 table has category, 4 tables have process which are sepearted by using aliases for modelling purpose

now when i click on one of the status, the reflexes doesnt get effective in other table/chart, why is this happening,

can anybody tell????

pls share some inputs on this, am confused, wqhy the data is not getting associated.???

Re: Linking problem

Thu, 20 Jun 2013 13:40:30 GMT

Basically you have to think about the Outer join based on the data structure and you have to write join query or outer query whereever it's appicable and avoid the no of table present in the model with FILE_NO

Re: Linking problem

Thu, 20 Jun 2013 13:59:35 GMT

didnt get ur point...

can u pls elaborate y thr is need of outerjoin???/

Re: Linking problem

marksmunich — Thu, 20 Jun 2013 14:24:29 GMT

try renaming the all the status, since all the status are with different names like co_status, qr_status and qs-status, f_status and others... trying renaming the fields, then it must work.