topic Re: missing and zero values in QlikView

missing and zero values

Anonymous — Thu, 02 Jul 2015 09:40:15 GMT

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

Re: missing and zero values

ramoncova06 — Thu, 02 Jul 2015 15:33:53 GMT

try suppressing the null values in the set analysis

Re: missing and zero values

Anonymous — Thu, 02 Jul 2015 16:03:45 GMT

Thank you!

Re: missing and zero values

ramoncova06 — Thu, 02 Jul 2015 16:05:10 GMT

glad it worked

Re: missing and zero values

ziabobaz — Wed, 08 Feb 2017 10:02:25 GMT

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