topic Re: Columns value 0 in pivot table in QlikView

Columns value 0 in pivot table

Thu, 07 Mar 2013 10:08:27 GMT

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.

Re: Columns value 0 in pivot table

nirav_bhimani — Thu, 07 Mar 2013 11:01:30 GMT

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

Re: Columns value 0 in pivot table

Thu, 07 Mar 2013 11:29:29 GMT

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

Re: Columns value 0 in pivot table

Thu, 07 Mar 2013 15:07:17 GMT

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.

Re: Columns value 0 in pivot table

MayilVahanan — Thu, 07 Mar 2013 15:25:46 GMT

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

Re: Columns value 0 in pivot table

Thu, 07 Mar 2013 16:16:48 GMT

Try with:

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

Hope it helps

Re: Columns value 0 in pivot table

Thu, 07 Mar 2013 16:21:41 GMT

I tried with an example and it works.

try with

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

Regards

Giampiero

Re: Columns value 0 in pivot table

Fri, 08 Mar 2013 10:55:20 GMT

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.

Re: Columns value 0 in pivot table

Fri, 08 Mar 2013 12:48:09 GMT

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

Re: Columns value 0 in pivot table

Mon, 11 Mar 2013 08:38:19 GMT

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