Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try suppressing the null values in the set analysis
try suppressing the null values in the set analysis
Thank you!
glad it worked
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