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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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 

 

Labels (1)
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())