topic Re: How to convert null(-) values into 0 in straight table in QlikView

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

Wed, 25 Nov 2020 16:16:04 GMT

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 .

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

Anonymous — Wed, 08 Jun 2016 06:31:29 GMT

Hi subbareddy,

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

Kind regards.

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

tamilarasu — Wed, 08 Jun 2016 06:33:34 GMT

Hi,

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

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

maleksafa — Wed, 08 Jun 2016 06:36:30 GMT

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.

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

bindu_apte — Wed, 08 Jun 2016 06:43:43 GMT

Hi,

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

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

beck_bakytbek — Wed, 08 Jun 2016 09:18:32 GMT

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

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

nicolas66 — Wed, 08 Jun 2016 09:26:06 GMT

Bonjour,

try Alt(a,0).

Bonne journée,

Philippe

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

pho3nix90 — Wed, 08 Jun 2016 09:40:52 GMT

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

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

susovan — Wed, 08 Jun 2016 11:24:11 GMT

Try this,