Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
];
Thanks Krishna. Will this work if column B is a subset of column C?
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