topic Re: Selections in two fields at time in QlikView

Selections in two fields at time

Thu, 18 Dec 2014 08:05:07 GMT

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.

Re: Selections in two fields at time

Thu, 18 Dec 2014 08:07:13 GMT

try using join

Re: Selections in two fields at time

Thu, 18 Dec 2014 08:10:11 GMT

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

Re: Selections in two fields at time

Thu, 18 Dec 2014 08:15:02 GMT

Bhawna is right, rename the fields.

Re: Selections in two fields at time

jyothish8807 — Thu, 18 Dec 2014 08:20:56 GMT

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

Re: Selections in two fields at time

saumyashah90 — Thu, 18 Dec 2014 08:28:18 GMT

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;

Re: Selections in two fields at time

Thu, 18 Dec 2014 10:31:53 GMT

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

Re: Selections in two fields at time

Anonymous — Thu, 18 Dec 2014 10:39:17 GMT

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

Re: Selections in two fields at time

jyothish8807 — Thu, 18 Dec 2014 10:41:19 GMT

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

Re: Selections in two fields at time

tresB — Thu, 18 Dec 2014 10:41:47 GMT

Check the attached qvw.

Re: Selections in two fields at time

MarcoWedel — Thu, 18 Dec 2014 11:48:36 GMT

Hi,

if for whatever reason you don't want to change your script/datamodel, then using field triggers and selection actions could help:

hope this helps

regards

Marco