Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vizz3108
Contributor II
Contributor II

Linking Filters values

I am new to Qlik. Please help.

I have 2 unrelated tables in my data model.

Columns  A and B belong to table 1.

Column C belongs to table 2. Columns B and C are the same fields with different names.

My Requirement:

Now if I make a selection in list box A, I will see its corresponding values in list box B since there is natural association. I need these entries which appear in List box B upon selection in list box A, to automatically appear in list box C.

So I want list box C to mirror list box B.

 

Thanks in advance.

Labels (2)
3 Replies
Qrishna
Master
Master

Pls Check the attached.

Capture.JPG

 

If the attached is not opening, Try the below script:

Table1:
Load * Inline [
ColumnA,ColumnB
1,p
2,q
3,r
];

Table2:
Load *, ColumnC AS ColumnB;
Load * Inline [
ColumnC
p
q
r
];

vizz3108
Contributor II
Contributor II
Author

Thanks Krishna. Will this work if column B is a subset of column C?

MarcoWedel

Hi,

I agree that the best way is to reflect these associations in the data model.
Just for reference I would like to add though that you can also select values in island tables using triggers and actions.
I.e. you could create an OnSelect field event trigger for the ColumnA field and add a "select in field" action to automatically select ColumnC field values based on a search string like 
='("'&Concat(DISTINCT ColumnB,'"|"')&'")'

hope this helps

regards

Marco