missing and zero values

[Anonymous]

Hi

I need to differentiate between missing and zero values. I have attached a piece of data (see Book.xlsx). You can see that on the one hand Brands 5 and 6 have a zero budget, on the other hand Brands 3,4,7,8, have no budget at all - it is missing.

When I create a chart in QlikView I'd like to supress missing values and show zero values. In order to do so I tried to customize my bar chart. I checked 'supress missing' and unchecked 'supress zero-values' on the Presentation tab. But it doesn't help. QlikView doesn't differentiate between missings and zero-values. It regards them equally as null.

Could you please help?

Thank you in advance,

Larisa

[ramoncova06 · Accepted solution]

try suppressing the null values in the set analysis

[Anonymous]

Thank you!

[ramoncova06]

glad it worked

[ziabobaz]

Ramon

I am having the same problem.

What I am supposed to do with your app if i use Sense?

A loaded it but I can't understand where i can find your set analysis expression.

Thank you