Unlink tables

[stekol61]

Hi!

In "Sheet1" in the enclosed report I have similar data from two data sources.

When I select "Date" in one table i updates the second table and this is OK.

When I select "HostName" in the left table I don't what the right table to be affected.

Same thing if select "NodeName" in the right table, the left table should not be affected..

Also the right table contains the object "Type". When this is selected only the right table should be affected

/Stefan

[robert_mika]

Hi Stefan,

I would first look for a unique Keys to  link your tables.

You have many synthetic keys that should be deal with first.

Go to Table Viewer

Synthetic Keys

Feeling Qlikngry?

How To /Missing Manual(25 articles)

[sujayrpatil]

Hi Stefan,

Using set analysis in your expressions you can achieve this. Use condition {<HostName=,Type=>} in your second table and  {<NodeName=>} in your first table.

[stekol61]

!Hi again!

I simplified the query so that only data for the the two tabled in "Sheet1" is loaded (See enclosed report).

The synthetic key seems to be OK but the problem remains

/Stefan

Don't know how to add the updated report to this message

[agomes1971]

Hi,

please see this

how to create link table in Qlikview?

HTH

André Gomes

[stekol61]

Hi!

Problem solved

/Stefan

[agomes1971]

Nice!