topic Re: Linking Filters values in QlikView

Linking Filters values

vizz3108 — Sun, 16 May 2021 13:20:25 GMT

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.

Re: Linking Filters values

Qrishna — Sun, 16 May 2021 06:28:08 GMT

Pls Check the attached.

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
];

Re: Linking Filters values

vizz3108 — Sun, 16 May 2021 13:21:35 GMT

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

Re: Linking Filters values

MarcoWedel — Sun, 16 May 2021 17:08:42 GMT

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