Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stekol61
Creator
Creator

Unlink tables

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

6 Replies
robert_mika
Master III
Master III

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
Partner - Contributor III
Partner - Contributor III

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
Creator
Creator
Author

!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
Specialist II
Specialist II

Hi,

please see this

how to create link table in Qlikview?

HTH

André Gomes

stekol61
Creator
Creator
Author

Hi!

Problem solved

/Stefan

agomes1971
Specialist II
Specialist II

Nice!