Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi.
Properties > Presentation
In the bottom left. Null Symbol chnage - to 0
Mark
Hi Mark,
That is not available in QlikSense. I wish that feature was there!!
Thanks
try tis,
if(isnull(urfield),'0',urfield)
Hi Shiva,
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.
Thank you,
David
Hi,
Sorry, Missed the QlikSense part, but have posted this under QlikView.
Mark
Hi,
Just had a little look and might be an option in script. NullAsValue?
NullAsValue A,B;
Set NullValue = 'NULL';
LOAD A,B from x.csv;
Mark
Hi David,
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.
try tis,
if(isnull(urfield) or urfield='-','0',urfield)
Maybe Try IF(ISNULL(field)=-1, 0,Field)