Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Filtering out "-" - no association

Hello,

Maybe anyone of you had similar problem.

I have two tables:

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?

Thank you

 

Regards

Michal

Labels (3)
3 Replies
Highlighted
Creator III
Creator III

Hi- 

"-"  meaning "NULL" book owner and by default Qlik cannot filter on Nulls (which is absolutely correct). You need to do following. 

1. Either you use "Mapping Load" on second table and place "NA" OR "-"  [note - "-" in this case is Character] to populate the non matching / Null Book names.

2. Left join second table to first table then use resident load on resultant table to populate the Null Book names in the second table

 

Highlighted
Specialist III
Specialist III

try is missing function

Channa
Highlighted
Contributor
Contributor

Hi Channa, can you please elaborate what you had in mind?
Thank you

Regards