Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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.
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
Try with:
if (isnull("NAVT_CODIGO")=-1, 'NO VISIBLE',"NAVT_CODIGO") as CodNavegacion,
Hope it helps
I tried with an example and it works.
try with
if(IsNull(NAVT_CODIGO)=-1,'NO VISIBLE',NAVT_CODIGO) as CodNavegacion
Regards
Giampiero
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.
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
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