Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to convert null(-) values into 0 in straight table

Hi all,

i have small confusion in straight table.

how to convert null(-) value into 0 means

in my straight table my data has

a            b

---         -----

-           10

10           -

-            -

my straight table showing above table.

i want show my straight table below how. please share me

a               b

---             ---

0             10

10             0

0              0

i want show my straight second one .

8 Replies
Anonymous
Not applicable
Author

Hi subbareddy,

On property objects, on presentation tab, uncheck Suppress zero-values, and Null Symbol and Missing Simbol may be 0 too.

Kind regards.

tamilarasu
Champion
Champion

Hi,

Go to Presentation Tab and write 0 instead of '-'  in Null symbol box.

Null.bmp

maleksafa
Specialist
Specialist

easiest way would be to go to the presentation tab and at the bottom set the null symbol to 0, other options would be to use the isnull() function in the expression and covert the values to 0. same thing can be applied in the reload script.

bindu_apte
Creator III
Creator III

Hi,

Please find the settings where you can change the null symbol '-' to '0'

Null symbol.jpg

beck_bakytbek
Master
Master

Hi subba,

i had such Problem in the case with TableBox, i am not sure, but you can try to do tha same way in case with straight table.

my way of proceeding does look like:

first step: in Script-Area;

NullAsValue*;

Set NullValue ='';

Load

if(len(trim([yourField]))= 0, 'yourSign', [yourField]) as YourName

Resident YourName;

i hope that helps

beck

nicolas66
Contributor III
Contributor III

Bonjour,

try Alt(a,0).

Bonne journée,

Philippe

pho3nix90
Creator II
Creator II

If you want to accomplish this model wide, then in script add the following under the environmental variables (default vars)

NullAsValue *;

Set NullValue = 0;

if you want to only do this per chart use the example Tamil gave you,

Alternatively, you could also do the below.

if(isNull(), 0, )

susovan
Partner - Specialist
Partner - Specialist

Try this,

Warm Regards,
Susovan