I am trying to display a 0 instead of the dash for the rows where I do not have a value to display.
Any suggestions on how to accomplish this in QlikSense?
Properties > Presentation
In the bottom left. Null Symbol chnage - to 0
That is not available in QlikSense. I wish that feature was there!!
Sorry, Missed the QlikSense part, but have posted this under QlikView.
Just had a little look and might be an option in script. NullAsValue?
Set NullValue = 'NULL';
LOAD A,B from x.csv;
I just tried your suggestion and it is still displaying - instead of the 0. I tried the 0 with quotes and without quotes to see if that had any impact. Neither worked.
if(isnull(urfield) or urfield='-','0',urfield)
Maybe Try IF(ISNULL(field)=-1, 0,Field)
You can achieve this by wither an expression in the front end like Shiva has suggested or the better way for performance sake do it in the script as Mark has specified. Works both ways.
Retrieving data ...