https://community.qlik.com/t5/QlikView/null-values-in-table/m-p/1638140#M446990 <P>Try this in your expression:</P><P>=If(Len(B) &lt;= 1 and not(IsNum(B)), C, Null())</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> Tue, 22 Oct 2019 06:38:42 GMT Arthur_Fong 2019-10-22T06:38:42Z https://community.qlik.com/t5/QlikView/null-values-in-table/m-p/1638136#M446987 <P>i want only null values or dash (' - ')&nbsp; value&nbsp; from table on first column</P><P>i attached file&nbsp;</P><P>&nbsp;</P> Tue, 22 Oct 2019 06:27:58 GMT https://community.qlik.com/t5/QlikView/null-values-in-table/m-p/1638136#M446987 capriconuser 2019-10-22T06:27:58Z https://community.qlik.com/t5/QlikView/null-values-in-table/m-p/1638138#M446988 <P>What is the expected result?</P><P>After clicking the button, what you want to show in the table?</P> Tue, 22 Oct 2019 06:32:29 GMT https://community.qlik.com/t5/QlikView/null-values-in-table/m-p/1638138#M446988 Arthur_Fong 2019-10-22T06:32:29Z https://community.qlik.com/t5/QlikView/null-values-in-table/m-p/1638140#M446990 <P>Try this in your expression:</P><P>=If(Len(B) &lt;= 1 and not(IsNum(B)), C, Null())</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> Tue, 22 Oct 2019 06:38:42 GMT https://community.qlik.com/t5/QlikView/null-values-in-table/m-p/1638140#M446990 Arthur_Fong 2019-10-22T06:38:42Z