topic Re: Linked Table Data Not Showing in QlikView

Linked Table Data Not Showing

goro2010 — Mon, 11 Mar 2013 14:11:09 GMT

Hello Everyone,

I have two tables linked with the same identifier, I use the LogId for the link but my data is not pulling thru as per screenshot below, AssetId is among one of them:

Here is the Table information:

Here is how the tables link:

I have tried to link it with INNER, OUTER and LEFT but no luck, any help would be appricated.

Thanks

Re: Linked Table Data Not Showing

alexandros17 — Mon, 11 Mar 2013 14:15:40 GMT

Everything seems ok, could you please provide the document?

Re: Linked Table Data Not Showing

swuehl — Mon, 11 Mar 2013 14:21:16 GMT

It seems that your tables are linked by more than 1 common field, you should get notified that a synthetic key has been created during script execution (you will also see the syn key if you switch table viewer to 'internal tables' view).

This might also explain that you don't get a your tables linked like expected.

Re: Linked Table Data Not Showing

goro2010 — Mon, 11 Mar 2013 14:28:20 GMT

Hi,

Only the LogId is a sync key as it should be, print screen is below, I have tried everyting I know to get the data pulled, I have verified that the LogId does exist in both tables.

I am running out of ideas

Re: Linked Table Data Not Showing

swuehl — Mon, 11 Mar 2013 16:40:58 GMT

I assume above picture shows fields used in a chart object as dimension / fields displayed in list boxes (and I assume above is only a portion of all available fields in your data model).

If so, it might not show the full picture. You need to look at the table viewer to discover synthetic keys.

Re: Linked Table Data Not Showing

goro2010 — Mon, 11 Mar 2013 18:33:10 GMT

Hi,

As per previous requests, please find my entire database..

As you can see there is no sync issues

Anything else I can look at?

Re: Linked Table Data Not Showing

swuehl — Mon, 11 Mar 2013 21:07:45 GMT

The tables will only link correctly if you've got matching, identical field values for field LogId in both tables (V_OBJ_Equipment and V_OBJ_Event3), same for TrimDate in tables Calendar and V_OBJ_Event3. Especially for TrimDate, take care that you don't link a timestamp (maybe formatted as date) with a date (i.e. a floating point to an integer).

You can check this by creating a list box with expression num(TrimDate).

Re: Linked Table Data Not Showing

goro2010 — Tue, 12 Mar 2013 06:54:48 GMT

Thanks, the issue was with the dates