Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

null values in table

i want only null values or dash (' - ')  value  from table on first column

i attached file 

 

2 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

What is the expected result?

After clicking the button, what you want to show in the table?

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try this in your expression:

=If(Len(B) <= 1 and not(IsNum(B)), C, Null())