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: 
PaoloGuerra
Creator
Creator

Impossible filter empty values in table

Hi,

have a table and I want to filter all null values in the field "Db_User_name". 
I deselected "Don't show null values" in all fields. But there is a lot a values empty in the table (yellow cells).

1.jpg

I checked the source data with notepad ++. It is a csv file. The corresponding field is empty.

2.jpg

There is an expression in the field "Db_user_name"

Spoiler
If(match(DB_User_Name_Comb_Machine_Learning,'NT AUTHORITY\SYSTEM', 'DBSNMP', 'SYS', 'UNISALUTE', 'APPS', 'WEB', 'SA', 'SYSTEM', 'EPVADMIN', 'SA', 'EDPSVIL', 'PRALFAUS', 'RPTVCF', 'APPLSYSPUB', 'CONSULTA', 'DW5', 'ZENA', '?')=0,
DB_User_Name_Comb_Machine_Learning,
Null()
)


I don't understand what the problem is

Can you help me please?

 

Labels (1)
1 Reply
PaoloGuerra
Creator
Creator
Author

Sorry, but I found the solution to the problem.

If(match(FieldName,'')=0,
FieldName,
Null()
)