How to suppress zero value rows in a table?

[shirleyk]

I have a simple table like this:

Region     Sales

A               100

B               0

C               200

When i use the expression Sum(Sales), Region B appears in the table. Is there any way to make those zero value rows disappeared? Thanks.

[Anonymous · Accepted solution]

see this:

How to skip zero values

QlikView Addict: Excluding Zeros in Set Analysis

[shirleyk]

Thanks. I've checked the "Show zero values" options and it is hidden now.

[Anonymous]

[KishoreSuri]

Hi,

Please explain how  and where  you have checked "  "Show zero values" options in QlikView. Please share screenshot,it will help more.