Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
mark6505
Valued Contributor III

Re: Display 0 in pivot table instead of - (NULL)

Hi.

Properties > Presentation

In the bottom left. Null Symbol chnage - to 0

Mark

Not applicable

Re: Display 0 in pivot table instead of - (NULL)

Hi Mark,

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

Thanks

buzzy996
Honored Contributor II

Re: Display 0 in pivot table instead of - (NULL)

try tis,

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

Not applicable

Re: Display 0 in pivot table instead of - (NULL)

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

mark6505
Valued Contributor III

Re: Display 0 in pivot table instead of - (NULL)

Hi,

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

Mark

mark6505
Valued Contributor III

Re: Display 0 in pivot table instead of - (NULL)

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

reddys310
Honored Contributor II

Re: Display 0 in pivot table instead of - (NULL)

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
Honored Contributor II

Re: Display 0 in pivot table instead of - (NULL)

try tis,


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

mark6505
Valued Contributor III

Re: Display 0 in pivot table instead of - (NULL)

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