Bar Chart not displaying bars for null

qlikvw2019 — Wed, 25 Nov 2020 16:16:04 GMT

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])
, '#.%')

Re: Bar Chart not displaying bars for null

Nicole-Smith — Tue, 11 Jun 2019 21:25:07 GMT

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])
, '#.%')
)

topic Bar Chart not displaying bars for null in QlikView

Bar Chart not displaying bars for null

Re: Bar Chart not displaying bars for null