topic remove hyphen from table box in QlikView

remove hyphen from table box

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am getting hyphens instead of blank values in Tablebox, is there any setting I can apply to remove hyphens and display bank values?

Re: remove hyphen from table box

Digvijay_Singh — Tue, 13 Sep 2016 02:26:58 GMT

hyphen means 'Null' as some of the field values are not associated with other field values of table box as per your data model. If you want to show null as blank in straight table, there is option in presentation tab at the bottom, don't think same option is there in table box. Through script we may convert nulls to other symbols but it has impact on aggregate formulas, count function will consider them.

Example from manual:

NullAsValue A,B; //A,B fields having nulls will be treated as values.

Set NullValue = ' ' ; //Null will appear as blank

Load A,B from x.csv;

Re: remove hyphen from table box

ramasaisaksoft — Tue, 13 Sep 2016 12:39:07 GMT

Hi Vibhu,

is there any chance to use straight table instead of table box ?

if your answer is YES then change into Straight table and go to ->Presentation tab->Left hand side last you can find 2 things

Null symbol & Missing symbol boxes .

change there as per your wish.