Showing null values

[#1]

I need show null values in a Pivot table. Somebody help-me?

Cause I need analise productos without any sale.

[jonathandienst]

Hi

Depends on whether you want to show null values, or display the dimensions even when there is no data against that dimension:

If null, use NullAsValue <fieldname> to replace null values with blanks (which are valid values, and will display in liat boxes etc).

If missing, you need an island dimension to show the dimension values even when there is no data. Search the forum for "date island" or "island adimension" for examples.

Regards

Jonathan

[#3]

Where I put NullAsValue ?

[#4]

I tryed but don't work.  Sorry.

[CELAMBARASAN]

Hi,

     Properties-->Presentation-->Uncheck the suppress zero values option.

     Properties-->Dimension-->Check the Show all values options

Celambarasan

[erichshiino]

Hi, Afranio.

I'm not sure if this will be enough in your case, but in the 'Dimensions' tab of the object properties, you can enable the check box 'Show All Values'

I updated your app with this property.

Hope this helps,

Erich

[#7]

I can't use Show All Values cause I need filter by Customer and/or Supliers. Sorry

Regards!

[CELAMBARASAN]

Hi,

     What output are you trying to achieve?

Celambarasan

[#9]

I need filter

Date = 03/16/2012

Suplier = xMARKET

Customer = All

Pivot table will be:

                              Afranio     Neymar

Milk                              30                              0

Cookie          0            0

Coffee           5                              0

----------------------------------------

If I filter:

Date = 03/14/2012

Suplier = xMARKET

Customer = All

                              Afranio      Neymar

Milk                              0                              5

Cookie                         10                              0

Coffee         0             0

----------------------------------------

If I filter:

Date = 03/14/2012

Suplier = xMARKET

Customer = Afranio

                              Afranio

Milk                              0

Cookie        10

Coffee          0

[#10]

Is it possible  with Qlikview? Domebody can help-me ?