Table 1 contains: Book Name, Account, Amount (let's say there's two hundred books here)
Table 2 contains: Book Name, Book Owner (let's say there's 10 books here)
I associated two table by book name. Now, important thing for me is to be able to sort out those books that have no Book Owner and checked what accounts are there. So I created a table in Qlik and tried to filter out clicking on the "-" symbol in the table. And as it works great for the place where the book owner's name is displayed it seem not to work for "-". This field is also greyed out in the table. Does that mean that I cannot filter out those fields for which there's no association?
To make it clearer, if I did vlookup in table 1 returning there Book Owner from table 2 I would need to filter out #N/A- meaning rows where Book Owner was not found.
Can you please advise whether this is possible at all or do I have to make vlookup before I upload data to Qlik?