topic Unlink tables in QlikView

Unlink tables

stekol61 — Thu, 01 Sep 2016 09:28:26 GMT

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

Re: Unlink tables

robert_mika — Thu, 01 Sep 2016 10:58:52 GMT

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)

Re: Unlink tables

sujayrpatil — Thu, 01 Sep 2016 11:08:00 GMT

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.

Re: Unlink tables

stekol61 — Thu, 01 Sep 2016 13:42:48 GMT

!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

Re: Unlink tables

agomes1971 — Thu, 01 Sep 2016 14:30:16 GMT

Hi,

please see this

how to create link table in Qlikview?

HTH

André Gomes

Re: Unlink tables

stekol61 — Fri, 02 Sep 2016 09:02:28 GMT

Hi!

Problem solved

/Stefan

Re: Unlink tables

agomes1971 — Fri, 02 Sep 2016 14:35:59 GMT

Nice!