Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
adidac
Contributor
Contributor

show variable parameters in differnt Tables on a Dashboard

dear community,

I would like to have a selected value filled on a sheet and several different tables.
The selected value must change a selection in another field with a non-identical heading.

I would like to change the selection in another table at the same time as selecting the work name. Here, the selection of the plant name should simultaneously adjust the goods recipient, so that the user only has to make one selection.


How can I imagine the code for this.

Is it possible? 


I do not know how to do this.


thanks in advance.

 

best regards

Maik

1 Reply
chrismarlow
Specialist II
Specialist II

Hi,

I think you should be able to use P() function & set analysis, so on the table you filter on the other field use something like {<[Plant Name]=P({$} [Work Name])>} as the set (you may need to either use {1} instead of {$} or cancel the selection on [Work Name] by using [Work Name]= in your set depending on your data model and how you want it handle other selections).

Result something like this;

20210825_1.png

Cheers,

Chris.