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.
PruebaValoresCero.qvw 198.0 K
Sorry, it isn´t work.
I attached other document qvw, in the script with tables "LOAD * INLINE" simulating my real situation.
I need help.
PruebaValoresCero2.qvw 166.8 K
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