Condition for missing value

[Anonymous]

Good day!

My task is to make conditions for missing value.

I have sales points and make pivot table with such dimensions:

1. Sales Point

2. Date.

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')

[ecolomer]

If you have a pivot table, in the label Presentation, you can select the sign to show when is Null

[Anonymous]

Thank you.

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.)

my expr:

if(WeekWorkingDays=1, if(sum(sales)...here must be condition when sales is missing,'!','V') ,'not working')

[ecolomer]

the condition is:

IsNull(Sum(sales))

[MayilVahanan]

hi

You can use like this

=if(sum(sales), 'V', '!')

[Anonymous]

this expression show me '-' for missing value ((

[PrashantSangle]

Hi,

Try like

if(WeekWorkingDays=1, if(not isnull(sum(sales)),'V','!') ,'not working')

Regards

[#8]

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

[Anonymous]

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 .

[Anonymous]

Thank you.

I know, that null and missing are different things. That's why i want to know what function or condition will get me missing value