same selection across two separate unlinked tables

[robmarr789]

Attached is a qlikview file with two separate tables.

I'm trying to get it so that if I click on 'bike' in the category field in table 1 then it will also select all the bikes (if there were more than 1) from table 2.

Seems like it should be quite easy but can't figure it out.

FYI - the tables are deliberately seperate with non matching field names

If you could reattach with the solution so I can see how you've done it that would be great!

Thanks

[vishsaggi]

Try this on your field event trigger field using document properties like below:

Open document properties : Ctrl+Alt+D -> triggers tab -> Field event triggers -> Select the field -> Select button OnSelect -> Add action -> Select in Field -> category_1 -> = GetFieldSelections(category)

[PabloTrevisan]

Is there a reason for not having a relationship? For it would be more appropriate to have no islands in your model.

[manoranjan_d]

i think we have do the same trigger to category_1 as vice versa

[vishsaggi]

Yes if you select on category_1 field then just follow the same.

[robmarr789]

great, that worked. Do you know how I make it so that it will display no results in table 2 if there were no 'bike' records in catergory_1?

[manoranjan_d]

i can give idea to to do this

follow the below steps

step 1)in category_1 table --> properties--> layout--> conditional =GetFieldSelections(category)=GetFieldSelections(category_1)

step2) create text box with name called "No data matching to Category"

properties--> layout--> conditional

=(GetFieldSelections (category) <> GetFieldSelections(category_1))

step3)

place the text box behind the category_1 table.

similary apply these to vice versa to category1 tabel and create text box