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?
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.
Just had a little look and might be an option in script. NullAsValue?
Set NullValue = 'NULL';
LOAD A,B from x.csv;
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.