Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Bar Chart not displaying bars for null

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

1 Reply
Highlighted

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