Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display 0 in pivot table instead of - (NULL)

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?

10 Replies
Mark_Little
Luminary
Luminary

Hi.

Properties > Presentation

In the bottom left. Null Symbol chnage - to 0

Mark

Not applicable
Author

Hi Mark,

That is not available in QlikSense. I wish that feature was there!!

Thanks

buzzy996
Master II
Master II

try tis,

if(isnull(urfield),'0',urfield)

Not applicable
Author

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

Mark_Little
Luminary
Luminary

Hi,

Sorry, Missed the QlikSense part, but have posted this under QlikView.

Mark

Mark_Little
Luminary
Luminary

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

reddy-s
Master II
Master II

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.

buzzy996
Master II
Master II

try tis,


if(isnull(urfield) or urfield='-','0',urfield)

Mark_Little
Luminary
Luminary

Maybe Try IF(ISNULL(field)=-1, 0,Field)