Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Asiolinka
Contributor III
Contributor III

Population without null records

Hi,

How can I use WHERE with NULL to obtain population without null records for chosen field?

Tried where LEN(FIELDNAME)>0 but it is  not working with real results.

Thank you in advance.

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

@Asiolinka  try this then

where LEN(trim(FIELDNAME))>0 or not isnull(FIELDNAME)

View solution in original post

6 Replies
Kushal_Chawda

@Asiolinka  LEN(trim(FIELDNAME))>0

Rams-
Creator
Creator

Hi, 

You can use where (Fieldname) < > 0  in backend

If you need further help,  can you share your dataset? 

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

Asiolinka
Contributor III
Contributor III
Author

It does not work. 

I found 100 nulls (by using IsNull) in one field. 

Now I need to find another errors but using population without 100 nulls I found. 

Tried LEN/trimLEN -> population still include number of nulls 

where (Fieldname) <> 0 population is bigger than this with nulls.

I should have smaller population after excluding Nulls..  

Rams-
Creator
Creator

Can you share your data table

Asiolinka
Contributor III
Contributor III
Author

I am so sorry but I can not show it here. 

 

Kushal_Chawda

@Asiolinka  try this then

where LEN(trim(FIELDNAME))>0 or not isnull(FIELDNAME)