Replace to zero

Hi,

try below methods,

Method 1:

if(Len(groupvalue)<=0 or IsNull(groupvalue) or groupvalue='-',0,groupvalue)

Method 2: // best approach

Alt(Sum(groupvalue), 0)

Method 3: // best approach

try to define null variable like below

NULLASVALUE *;

SET NullValue ='NULL' ;

or

SET NullValue ='-' ;

Still if you have issue, i would suggest you to provide the sample mock data and expected output. Thanks

Hope this helps to you

Regards,

Deva

try this

if(isnull(groupvalue),'0',groupvalue)

All Solutions by Deva should work. if "group value" is a field then [groupvalue] if it is a label than replace group value with the expression.

if(len(trim(groupvalue))>0,groupvalue,0)

Is it null or is it missing.... I think it would not be possible to replace missing value with 0 in the chart itself. In order to do this you would probably need to generate missing data in the script

Generating Missing Data In QlikView