Columns value 0 in pivot table

[#1]

Hi,

I have a pivot table with two dimensions and an expression.

The problem is in the second dimension that has value 0 in the last column. If I check suppress value null in this dimension (in the tab), the other dimension doesn´t show the values zero in their content . I don´t want it.

I attached the qvw and other picture with I want to do.

Thanks.

[nirav_bhimani]

Hi,

In the Pivot table that option is disabled but If u use straight table then it shows that Option In the Expression Tab Show Total -> No Total Radio Button.

Regards,

Nirav Bhimani

[#3]

Hi,

the way I thought is this.

In your script change the Value Null for that Field with a string. For instance "NOT VISIBLE"

Then, in your pivot table build your dimension in this way:

IF(NombreTipoNavegacion <> 'NOT VISIBLE', NombreTipoNavegacion)

It should work.

Hope it helps

Regards

Giampiero

[#4]

Thank you, but it isn´t work.

In the script I write:

if (isnull("NAVT_CODIGO"), 'NO VISIBLE',"NAVT_CODIGO")  as CodNavegacion,

but the result in the pivot table is the same. I dont know the value zero.

I attached the qvw again.

[MayilVahanan]

Hi

Is not zero, its missing value... When map with tables, there is mismatch between CodNavegacion and NombreAP.

Properties -> presentation -> Null symbol and missing symbol is assigned as Zero.. so 0 appear for missing value and null value..

Hope it helps

[#6]

Try with:

if (isnull("NAVT_CODIGO")=-1, 'NO VISIBLE',"NAVT_CODIGO")  as CodNavegacion,

Hope it helps

[#7]

I tried with an example and it works.

try with

if(IsNull(NAVT_CODIGO)=-1,'NO VISIBLE',NAVT_CODIGO) as CodNavegacion

Regards

Giampiero

[#8]

Sorry, it isn´t work.

I attached other document qvw, in the script with tables "LOAD * INLINE" simulating my real situation.

I need help.

Thanks,

Marta.

[#9]

Hi Marta,

The problem is in these two tables "PeriodoProceso" & "AutoridadPortuaria".

In "PeriodoProceso" you have AUTP_ID = 12 and 34 that have a correspondence with AUTP_ID in AutoridadPortuaria but in PeriodoProceso you have null values for PEPR_ID and MES_ID.

For that reason you're facing your problem.

My advice is, when you create the "PeriodoProceso" table, don't put in that null values for PEPR_ID and MES_ID.

SO, If these two fields are null (in the same record) don't put it in your table.

You wouldn't have any problem doing that.

I think it should solve your problem.

Hope it helps

regards

Giampiero

[#10]

But in the "PERIODOPROCESO" table may not proceed all records exist.

Is it possible that the result is the one I want?

The result I desire is in the attached file.

thanks