Bar Chart not displaying bars for null

[qlikvw2019]

I have DBTECH  as the dimension on my bar chart.  It displays  % completion for each DBTech.  The data for DB2LUW has no status=COMPLETED . i am trying to have the Bar chart display 0% for DB2LUW. Please suggest how I can achieve this

I have below expression in the chart

Num(
Count({<[Status]={"COMPLETED"}>}[Status])
/
Count({<[DB Tech]={"SQL","ORACLE","DB2-LUW"}>}[DB Tech])
, '#.%')

[Nicole-Smith]

If you use one of the RangeSum/RangeAvg functions, it should replace your NULL value with a zero.  Just wrap your function in one of them:

RangeSum(
Num(
Count({<[Status]={"COMPLETED"}>}[Status])
/
Count({<[DB Tech]={"SQL","ORACLE","DB2-LUW"}>}[DB Tech])
, '#.%')
)