Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Delete rows that only contain 0 (zero) as value

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

1 Solution

Accepted Solutions

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

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


talk is cheap, supply exceeds demand
5 Replies

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

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


talk is cheap, supply exceeds demand
Not applicable

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

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.

Not applicable

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

Hi Peter,

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

deepaktibhe
Valued Contributor

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

use isnull function.

Thanks

Not applicable

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

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

Community Browser