topic Re: Re: Linking Tables (loop) in Qlik Learning Discussions

Linking Tables (loop)

Thu, 06 Nov 2014 20:56:46 GMT

Hello community,

Attached you find a file with the table view of my tables.

There are two main tables: Customersheet and Hatcherysheet.

The customer sheet got a field: CLIENT, however the hatcherysheet got 5 fields with CLIENT (1CLIENT, 2CLIENT, 3CLIENT, 4CLIENT, 5CLIENT). I created a Crosstable of these five fields to create one: CLIENT.

When I run the script it gives me an error that this crosstable is 'loosely' connected, which basically means it isn't

How do I get the field CLIENT to match with those crosstable directly, or... option 2, how do I get CLIENT field in the CustomerSheet to be linked to the 5 fields mentioned above?

Cheers guys!

Jarl.

Re: Linking Tables (loop)

Fri, 07 Nov 2014 05:58:54 GMT

Hi Jarl,

I think the best way to do it is to use Link Tables,

How did you connect the 5 tables to form hatcherysheet? did you use concatenate load?

Re: Linking Tables (loop)

Fri, 07 Nov 2014 13:14:11 GMT

Charles, thanks for helping out.

All the tables I loaded in a simple LOAD fashion. See below this message the table order load.

Please advise on what you mean Link Tables and how to do it? I thought making the variable name the same was sufficient.

HATCHERYSHEET:

LOAD
ID2

[...],

CLIENTHATCH:

CrossTable(Clients, CLIENT)
LOAD ID2,
    [1CLIENT],
     [2CLIENT],
     [3CLIENT],
     [4CLIENT],
     [5CLIENT]

THEN TWO OTHER CROSSTABLES ON ID2:

CrossTable(Incubator, Data)
LOAD ID2,

[...]

CrossTable(Hatcher, Data2)
LOAD ID2, [...]

CUSTOMERSHEET:

LOAD

[...]

CROSSTABLE FOR CUSTOMERSHEET:

CrossTable(Origen, N_Poults_Origen)
LOAD
ID,
SEK,

Re: Linking Tables (loop)

Mon, 10 Nov 2014 19:11:48 GMT

Bump. Charles or anyone else can help me with the above problem.

Thanks.

Re: Linking Tables (loop)

Tue, 11 Nov 2014 06:43:24 GMT

Hi jarl,

can you attached a sample qv file?

Re: Re: Linking Tables (loop)

Tue, 11 Nov 2014 18:28:06 GMT

Thanks Charles, I have added two excel documents and the qvd file.

I wish that when I click on a name in the box: Client, the correct % hatch of set, and % mortality shows up. In addition to the crosstable of the hatchers I have used.

Any help is welcome.

Jarl.