topic Re: Delete rows that only contain 0 (zero) as value in QlikView

Delete rows that only contain 0 (zero) as value

Thu, 21 Aug 2014 12:27:52 GMT

Hello

I got several pivot tabels that hold rows where all values are 0 or empty.

By default I always get a row with "-" in the dimensions of the pivot tabele.

How can I get rid of them so I don't see them anymore?

Thanks Peter

Re: Delete rows that only contain 0 (zero) as value

Gysbert_Wassenaar — Thu, 21 Aug 2014 12:35:59 GMT

Make sure the option Suppress Zero-Values is enabled on the Presentation tab. And that Show All Values is not enabled for the dimensions of your pivot table

Re: Delete rows that only contain 0 (zero) as value

Fri, 22 Aug 2014 06:48:24 GMT

So somehow that dosn't work here, I still got rows in the pivot where all values are 0. Can it cause of the dimensions, so I got QuarterYear and inside the Month, where for example two months have only 0 values.

Re: Delete rows that only contain 0 (zero) as value

Fri, 22 Aug 2014 07:40:42 GMT

Hi Peter,

Would it be possible to provide us with a small data sample where you are experiencing the issue?

Re: Delete rows that only contain 0 (zero) as value

deepakqlikview_123 — Fri, 22 Aug 2014 12:15:03 GMT

use isnull function.

Thanks

Re: Delete rows that only contain 0 (zero) as value

Thu, 02 Oct 2014 06:53:40 GMT

Okay, so my problem was that I didn't tick the "don't show NULL' not for all dimensions