topic Re: same selection across two separate unlinked tables in QlikView

same selection across two separate unlinked tables

robmarr789 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: same selection across two separate unlinked tables

vishsaggi — Tue, 21 Aug 2018 17:49:06 GMT

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)

Re: same selection across two separate unlinked tables

PabloTrevisan — Tue, 21 Aug 2018 17:53:22 GMT

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

Re: same selection across two separate unlinked tables

manoranjan_d — Tue, 21 Aug 2018 19:12:39 GMT

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

Re: same selection across two separate unlinked tables

vishsaggi — Tue, 21 Aug 2018 19:19:54 GMT

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

Re: same selection across two separate unlinked tables

robmarr789 — Thu, 23 Aug 2018 07:45:12 GMT

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?

Re: same selection across two separate unlinked tables

manoranjan_d — Thu, 23 Aug 2018 11:10:08 GMT

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