Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Em60
Contributor
Contributor

How to filter to exclude Nulls in a Qlik table?

Hello, I am a new beginner. Is there anybody here who can help me to exclude the nulls in the following  given table?

Capture.JPG

 

Labels (2)
4 Replies
joaopaulo_delco
Partner - Creator III
Partner - Creator III

Hi @Em60 !

     Just uncheck the follow dimension field like below on dimension proprierties:

joaopaulo_delco_0-1617901071603.png

 

Help users find answers! Don't forget to mark a solution that worked for you!
Em60
Contributor
Contributor
Author

Thanks for the response. The problem is that I don't have access to the menu that you mentioned. 

Is there any other way to exclude Nulls in the following search box?

 

Em60_0-1617902806551.png

 

abhijitnalekar
Specialist II
Specialist II

Hi, 

There is no direct option to do the same. but you can set null values as below.

 

  1. In Data manager, select a table and click 

     

    .
  2. Select a field.
  3. In the data profiling card, click the Set nulls card.
  4. Under Distinct values, select the values you want set as null.
  5. Click Set null values.
Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
Sammy_AK
Creator II
Creator II

from the selection menu, click on "..."  this will provide you further options where by either selecting "Select All" or "Select Possible" you can get rid of null values from the table and also you can store this as a bookmark for any future references. 

Sammy_WORK_0-1622486186077.png