Selections in two fields at time

[#1]

Hi, I have two fields in two tables that can have the same values. I want to select/deselect a value in one of the fields and have the same selection in the other field. For example:

Table1:

LOAD * inline [

     FIELD1, FIELD2

     A,1

     B,2

     C,3

];

Table2:

LOAD * inline [

     FIELD3, FIELD4

     A, asd

     B, fgh

     C, ijk

];

I want if I select in FIELD1 the value A, FIELD3 have the same selection. If I delete this selection, I want to delete in FIELD3 too. And the same if I select a value in FIELD3, I will have the same selection in FIELD1.

How can I get this?

Thanks.

[#2]

try using join

[#3]

rename FIELD1 to FIELD3 or FIELD3 to FIELD1,in qlikview linking is done by field name

[#4]

Bhawna is right, rename the fields.

[jyothish8807]

Hi,

Try renaming Field 3 as Field 1 and make it a primary key.

Table1:

LOAD * inline [

     FIELD1, FIELD2

     A,1

     B,2

     C,3

];

Table2:

LOAD * inline [

     FIELD3, FIELD4

     A, asd

     B, fgh

     C, ijk

];

load

FIELD3 as FIELD1,

FIELD4

resident Table2;

Drop Table Table2;

Regards

KC

[saumyashah90]

Hi,

Use the below script:

Table1:

LOAD * inline [

FIELD1, FIELD2

A,1

B,2

C,3

];

Table2:

LOAD * inline [

FIELD3, FIELD4

A, asd

B, fgh

C, ijk

];

Table:

Load

FIELD3 as FIELD1,

FIELD4

Resident Table2;

Drop table Table2;

[#7]

I cant rename the field because this make appear a circular relation. Two fields must have different names.

[Anonymous]

Do a left join so that your table will be combine.

[jyothish8807]

Hi Daniel,

In this case you will have to rename two table an attain this.

Use the approach to remove circular relation.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references

Regards

KC

[tresesco]

Check the attached qvw.