topic Re: Showing blank for Unwanted values in Table object in App Development

Showing blank for Unwanted values in Table object

aatish12345 — Thu, 28 Oct 2021 07:28:40 GMT

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

Re: Showing blank for Unwanted values in Table object

abhijitnalekar — Thu, 28 Oct 2021 09:03:54 GMT

Hi @aatish12345 ,

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

Re: Showing blank for Unwanted values in Table object

njc_96 — Thu, 28 Oct 2021 09:07:50 GMT

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!

Re: Showing blank for Unwanted values in Table object

stevejoyce — Thu, 28 Oct 2021 09:10:53 GMT

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])

Re: Showing blank for Unwanted values in Table object

aatish12345 — Fri, 29 Oct 2021 05:27:43 GMT

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

Aatish

Re: Showing blank for Unwanted values in Table object

abhijitnalekar — Fri, 29 Oct 2021 06:13:08 GMT

Hi @aatish12345 ,

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

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

Re: Showing blank for Unwanted values in Table object

aatish12345 — Fri, 29 Oct 2021 07:55:38 GMT

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

Re: Showing blank for Unwanted values in Table object

aatish12345 — Wed, 03 Nov 2021 03:09:47 GMT

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