Showing blank for Unwanted values in Table object

[aatish12345]

Hello Everyone,

Currently in table object of Qlik Sense, if we use 2 fields and if 2nd field don't have relevant data for the data of 1st field, then by default it will show as "-" (dash) and grey bg color for such cells in the column. 

For such non relevant data I want to show it as blank with white space instead of dash and grey bg color.

Can anyone plz help to achieve it

Aatish

[abhijitnalekar]

Hi @aatish12345 ,

Do you have used any expression to derive a 2nd field or its coming from the database

[Jyothi_Challa]

Hi @aatish12345 ,

Please use the below lines before loading the table. These lines converts the nulls into values

NullAsValue FIeld2;  

Set NullValue = ' ';  // Added space as per the requirement

Reference Link:

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptR...

Hope this solution helps you!

Thanks!

[stevejoyce]

In the beginning of your load script you can set display text for null values.

NullAsValue revenue;
set NullValue = '<no revenue>';

NullAsValue budget;
set NullValue = '<no budget>';

if it's for an expression on your front-end you can use alt (alt must take a numeric response) or if isnull.

alt(max(revenue), '')

if(isnull([text field]),'', [text field])

[aatish12345]

Yes in the load script I am deriving new fields by using already loaded fields 

Aatish

[abhijitnalekar]

Hi @aatish12345 ,

You can also use the COALESCE() function to replace the null values for the specific field.

eg. COALESCE(Field2,''Others) as Field2

[aatish12345]

Hi all, thanks for the help..

I 1st tried using NullasValue then I tried if(isnull(field2),'',field2) , but in both the case I got more no. of records which are not matching with my original code

Aatish

[aatish12345]

Hi Abhijit,

The 2nd field is derived one and it's coming from a table which is associated with the table consisting 1st field

Aatish