topic Re: Condition for missing value in QlikView

Condition for missing value

Anonymous — Mon, 29 Dec 2014 11:22:33 GMT

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

Re: Condition for missing value

ecolomer — Mon, 29 Dec 2014 11:28:12 GMT

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

Re: Condition for missing value

Anonymous — Mon, 29 Dec 2014 11:34:19 GMT

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

Re: Condition for missing value

ecolomer — Mon, 29 Dec 2014 11:36:51 GMT

the condition is:

IsNull(Sum(sales))

Re: Condition for missing value

MayilVahanan — Mon, 29 Dec 2014 11:37:28 GMT

You can use like this

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

Re: Condition for missing value

Anonymous — Mon, 29 Dec 2014 11:46:37 GMT

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

Re: Condition for missing value

PrashantSangle — Mon, 29 Dec 2014 11:50:08 GMT

Hi,

Try like

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

Regards

Re: Condition for missing value

Mon, 29 Dec 2014 11:50:53 GMT

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

Re: Condition for missing value

Anonymous — Mon, 29 Dec 2014 11:52:07 GMT

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 .

Re: Condition for missing value

Anonymous — Mon, 29 Dec 2014 11:58:52 GMT

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

Re: Condition for missing value

Anonymous — Mon, 29 Dec 2014 11:59:28 GMT

Thank you!

But it get me "-", not '!'

Re: Condition for missing value

Mon, 29 Dec 2014 12:01:22 GMT

Then you can try comparing the string. like if(sum(sales) = '-','!','V')

Re: Condition for missing value

Anonymous — Mon, 29 Dec 2014 12:03:57 GMT

Can you share your Sample QVW please.

Re: Condition for missing value

Anonymous — Mon, 29 Dec 2014 12:05:39 GMT

i can not compare missing value with "-", because it's not string value

Re: Condition for missing value

PrashantSangle — Mon, 29 Dec 2014 12:05:43 GMT

Hi,

If you want change - to ! then go to presentation tab

change missing symbol and Null Symbol to "!" instead of "-"

Or try in expression

if(not isnull(expression),expression,'!')

if(len(trim(expression))>0,expression,'!')

Regards

Re: Condition for missing value

Yoda300_ — Sun, 06 Oct 2019 13:41:07 GMT

Hi, did u find a solution ? I have the same issue, thanks to reply