Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Condition for missing value

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

15 Replies
ecolomer
Master II
Master II

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

Anonymous
Not applicable
Author

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
Master II
Master II

the condition is:

IsNull(Sum(sales))

MayilVahanan

hi

You can use like this

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable
Author

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

PrashantSangle

Hi,

Try like

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

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
Not applicable
Author

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
Not applicable
Author

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