Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Is there a reason for not having a relationship? For it would be more appropriate to have no islands in your model.
i think we have do the same trigger to category_1 as vice versa
Yes if you select on category_1 field then just follow the same.
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?
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