topic Re: delete some zero rows in pivot table in QlikView

delete some zero rows in pivot table

OmarHernandez — Wed, 25 Nov 2020 16:16:04 GMT

I want to know how to delete/hide selected rows in pivot table as show in pic

Re: delete some zero rows in pivot table

Claudiu_Anghelescu — Wed, 27 Mar 2019 10:21:05 GMT

Show data using this Expresison:
=if(Monto) =0, '', Monto)

And then "Suppress Null Values"

Re: delete some zero rows in pivot table

OmarHernandez — Wed, 27 Mar 2019 16:09:29 GMT

Claudiu

Thanks for your answered, but did not work

This is the expression

Monto=if(MontoRedistribucion_OCPB<>0,Sum(MontoRedistribucion_OCPB),'')

Sorry, but I'm begginer in qlikview

Re: delete some zero rows in pivot table

Claudiu_Anghelescu — Wed, 27 Mar 2019 20:41:34 GMT

You can try also this:

=if(sum(MontoRedistribucion_OCPB)<>0
or
sum(MontoRedistribucion_OCPB) <>'', sum(MontoRedistribucion_OCPB),'')

If is not works you can atrach a sample File .qvw