Replace missing by 0 (numeric format) in pivot table

[nicogene]

Dear all,

In a pivot table, I would like to replace missing value by 0 (numeric) but it doesn’t work.

Below my formula:

=num(if(IsNull( Count(Distinct SKey)),0,Count(Distinct SKey)),'# ##0')

Many thanks in advance for your help.

PS: a .qvw file is available in attachment.

Kindest regards,

Nicolas.

[NickHoff]

You don't need to use an if statement.  In your Presentation tab there is an option to populate missing cells, the default is -, you can change it to anything you'd like.

[agomes1971]

Hi,

If you go to presentation tab replace null symbol '-' for 0.

Is that what you want ?

HTH

André Gomes

[ste_berbenni]

Hi Nicolas,

you can open chart Properties, tab Presentation and in the bottom of the windows set "Missing symbol" like '0'

Regards,

Stefano

[nicogene]

Thanks for your reply.

With tab presentation, the problem is the following: it's a text format and not a numeric value.

Thanks  for your return.

Kindest regards,

Nicolas.

[rwunderlich]

On the Presentation tab, select the field and then "right" for text alignment.

-Rob

[nicogene]

Thanks for your response.

But when I realize an export to MS Excel, the format is text. I would like

to replace missing value by numeric value.

Kindest regards,

Nicolas.

Le mercredi 28 janvier 2015, Rob Wunderlich <qcwebmaster@qlikview.com> a

écrit :

[Anonymous]

Hi Nicolas

Actually when you checked suppress Zero Values . Qlikview consider 0 as null or missing. So just uncheck the option it will work.

Let em know if you are looking for something else.

[#9]

Hi Nicolas,

PFA.

Thanks,

Chiru

[Anonymous]

Sorry forget to attach the solution.

PFA