Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

andreyfcdk91
Contributor

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
Honored Contributor II

Re: Condition for missing value

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

andreyfcdk91
Contributor

Re: Condition for missing value

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
Honored Contributor II

Re: Condition for missing value

the condition is:

IsNull(Sum(sales))

Re: Condition for missing value

hi

You can use like this

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

andreyfcdk91
Contributor

Re: Condition for missing value

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

Re: Condition for missing value

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

Re: Condition for missing value

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

balkumarchandel
Valued Contributor II

Re: Condition for missing value

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 .

andreyfcdk91
Contributor

Re: Condition for missing value

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