topic Change empty fields to blank in QlikView https://community.qlik.com/t5/QlikView/Change-empty-fields-to-blank/m-p/1067607#M356884 <HTML><HEAD></HEAD><BODY><P>Is there a way to show empty fields in a straight table chart as blank instead of the '-'? I know you can do an if-else-condition in the expression, but with over 100 columns that would be a lot of manual work. Any easier way to accomplish this?</P></BODY></HTML> Wed, 02 Mar 2016 08:58:00 GMT 2016-03-02T08:58:00Z Change empty fields to blank https://community.qlik.com/t5/QlikView/Change-empty-fields-to-blank/m-p/1067607#M356884 <HTML><HEAD></HEAD><BODY><P>Is there a way to show empty fields in a straight table chart as blank instead of the '-'? I know you can do an if-else-condition in the expression, but with over 100 columns that would be a lot of manual work. Any easier way to accomplish this?</P></BODY></HTML> Wed, 02 Mar 2016 08:58:00 GMT https://community.qlik.com/t5/QlikView/Change-empty-fields-to-blank/m-p/1067607#M356884 2016-03-02T08:58:00Z Re: Change empty fields to blank https://community.qlik.com/t5/QlikView/Change-empty-fields-to-blank/m-p/1067608#M356885 <HTML><HEAD></HEAD><BODY><P>You can do this:</P><P></P><P><STRONG>If(Len(Trim(Field)) = 0, ' ', Field)</STRONG></P></BODY></HTML> Wed, 02 Mar 2016 15:38:45 GMT https://community.qlik.com/t5/QlikView/Change-empty-fields-to-blank/m-p/1067608#M356885 sunny_talwar 2016-03-02T15:38:45Z Re: Change empty fields to blank https://community.qlik.com/t5/QlikView/Change-empty-fields-to-blank/m-p/1067609#M356886 <HTML><HEAD></HEAD><BODY><P>Hi Daren,</P><P></P><P>Chart Properties -&gt; Presentation Tab -&gt; Replace the hyphen in null symbol and missing symbol by space.</P></BODY></HTML> Wed, 02 Mar 2016 15:40:28 GMT https://community.qlik.com/t5/QlikView/Change-empty-fields-to-blank/m-p/1067609#M356886 tamilarasu 2016-03-02T15:40:28Z Re: Change empty fields to blank https://community.qlik.com/t5/QlikView/Change-empty-fields-to-blank/m-p/1067610#M356887 <HTML><HEAD></HEAD><BODY><P>Do you put this in every single expression?</P></BODY></HTML> Wed, 02 Mar 2016 15:41:40 GMT https://community.qlik.com/t5/QlikView/Change-empty-fields-to-blank/m-p/1067610#M356887 2016-03-02T15:41:40Z Re: Change empty fields to blank https://community.qlik.com/t5/QlikView/Change-empty-fields-to-blank/m-p/1067611#M356888 <HTML><HEAD></HEAD><BODY><P>Thanks Tamil that works!</P></BODY></HTML> Wed, 02 Mar 2016 15:42:23 GMT https://community.qlik.com/t5/QlikView/Change-empty-fields-to-blank/m-p/1067611#M356888 2016-03-02T15:42:23Z