Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Changing background color for null values in qlikview pie chart

I have a pie chart which shows null values as a pie with a count. I want to change the background color of both the pie slice with null values and the legend to 255,255,255. Currently the legend shows '-' and the pie slice shows 19 as count. Now I want both to show white color. What is the expression to be put in the chart background color so that both shows white. Please share the expression and this has to be put in the expressions background color referencing the dimension status am I right. (not in dimensions background color)

basically change color of status which is '-' to white so that it reflects in the chart and the legend. Please share the expression as I am not sure if this is a null or a - or a blank. But want to display this telling them these many values need to be updated at back end.

1 Reply
prma7799
Master III
Master III

Please share sample app.