Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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())