My task is to make conditions for missing value.
I have sales points and make pivot table with such dimensions:
1. Sales Point
There are some dates with sales "-". It's missing value. Is there any way to set '!' for missing value in expression?
Such as.. if(sum(sales) <condition> for missing value,'!','V')
But it's not necessary solution for my task.
First, i use flag WeekWorkingDays, which get working days for my sales points.
And my task to set value, where sales in working days is "-" (missing.)
if(WeekWorkingDays=1, if(sum(sales)...here must be condition when sales is missing,'!','V') ,'not working')
So probably the values are not null, but actually no value is associated with the data set or condition or dimension-expression set that you are using. Missing Value and Null Values are 2 different things.
Check out: NULL handling in QlikView
Use this expression
if(WeekWorkingDays=1, if(len(sum(sales))=0,'!','V') ,'not working')
if this is not working for you can you post your sample QVW.
Will let you know how to do this .