Here is a simplified sample data to illustrate my question.
I have the 2 tables below:
I loaded both by going to EDIT SCRIPT, TABLE files.
Now in my qlikview worksheet, I have the following list box:
and the below tablebox:
I would like that the tablebox to show those that are not found i.e. Found <> "Yes".
The expected outcome is for the tablebox to show File3 / D
I tried selecting the YES in the found listbox and right click and SELECT EXCLUDED, but this resulted to all Filenames/Voucher showing up.
Thanks in advance for your help.