topic Re: Link between fields not established in QlikView

Link between fields not established

Sat, 21 Sep 2013 09:45:13 GMT

Hello friends

I am facing the following situation in my qlikview
project. As you can see after uploaded the data I get the following output:

However, whenever I pick any order some of the values fail
to show up as below e.g. employee id (no selection)

I am little confused as to why the employeeid are not showing even though the data is linked between order and order details table by orderid . Following is my internal table structure:

Following is my external table structure:

I am not able to make head or tail as to why the two tables are not linking by order id even though the link is shown in the above views.

Your guidance would be welcomed. Thank you to all for helping.

Cheers

Uday

Re: Link between fields not established

qlikpahadi07 — Sun, 22 Sep 2013 09:22:44 GMT

It's Because of Loops

I think if you Join Shippers Table with Orders as ShipperID as KEY it will solve your Problem.

As Link between Customers and Shippers with Company Name doesn't make any Sense.

Re: Link between fields not established

swuehl — Sun, 22 Sep 2013 10:31:33 GMT

Please check my response to your previous thread.

You are still having circular references / loops in your model.

Re: Link between fields not established

rajeshvaswani77 — Sun, 22 Sep 2013 13:45:21 GMT

Hi Uday,

1) Did the Order ID you select has an Employee ID linked?

2) Are the Employee ID's populated in the Order ID table and of the same format?

thanks,

Rajesh Vaswani

Re: Link between fields not established

Sun, 22 Sep 2013 15:48:36 GMT

Hey Mate,

Firstly, loops (indicated by the dotted association in table viewer) creates ambiguous/impossible logical associations. There are a few ways to get rid of the loop. My initial suggestion would be to remove CompanyName from Customers table. CustomerID is the primary association, therefore when linking to Orders you will still get all ShipperID's, even those that did not have any activity.

Let me know if this corrects the output in your chart object

Cheers,

Byron