topic IF and IsNull function in QlikView

IF and IsNull function

Anonymous — Fri, 26 Oct 2018 07:10:22 GMT

I'm trying to add an IF-function in the script:

IF (IsNull () and IsNull (), "Yes", "No")

The script says that the formula is okay, but it doesn't show the desired result.

Who can help me to discover the error in my formula?

Re: IF and IsNull function

m_woolf — Fri, 26 Oct 2018 16:59:07 GMT

You need single quotes:

IF (IsNull () and IsNull (), 'Yes', 'No') as SomeFieldName

Re: IF and IsNull function

Anonymous — Tue, 30 Oct 2018 13:52:24 GMT

I have tried it with single quotes, but still not the desired result.

Re: IF and IsNull function

atoz1158 — Tue, 30 Oct 2018 15:40:46 GMT

Please state what you are expecting.

The way I read your IF statement I would expect to get the following.

A	B	Result
A Value	A N Value	No
A Value	NULL	No
NULL	A N Value	No
NULL	NULL	Yes

Is this what you are getting?

If you are expecting to get Yes when either A or B is NULL then you need to change your AND to an OR

Adrian

Re: IF and IsNull function

Anil_Babu_Samineni — Tue, 30 Oct 2018 15:45:58 GMT

May be try this?

IF (IsNull (), If( IsNull (), "Yes", "No"))

Re: IF and IsNull function

m_woolf — Tue, 30 Oct 2018 16:51:43 GMT

What are your desired results?

Re: IF and IsNull function

Anonymous — Wed, 31 Oct 2018 11:49:51 GMT

It doesn't work unfortunately.

But thanks for the help.

Re: IF and IsNull function

Anonymous — Wed, 31 Oct 2018 11:52:59 GMT

This is exactly where I'm looking for.

But by using my formula it gives:

A	B	Result
A Value	A Value	No
A Value	NULL	No
NULL	A Value	Yes - should be No
NULL	NULL	Yes

Re: IF and IsNull function

m_woolf — Wed, 31 Oct 2018 17:59:41 GMT

Logic is OK.

Can you post a sample qvw showing the problem?

Re: IF and IsNull function

vishsaggi — Wed, 31 Oct 2018 18:24:46 GMT

May be try using

IF( Len(Trim()) = 0 AND Len(Trim()) = 0, 'Yes', 'No')

Re: IF and IsNull function

shashipraband — Wed, 31 Oct 2018 19:32:26 GMT

Hi Natascha,

It is working for me, I tried this using the inline table for the example you mentioned above.

I defined null as blank in below script.

Input:

Set nullinterpret='';

Load *, IF (IsNull (A) and IsNull (B), 'Yes', 'No') as NullValue;

Load * inline[

A,B

A Value,A Value

A Value,

,A Value

]

Output in front-end:

Note: Please check you may be assuming a blank value as null, but it may not be true always. It may be an empty string. So if it is a real null value(not an empty string) then if you click on it, it should not get selected and no changes should happen. And one more observation you can do is null values will not visible in list box. Just check.

Regards

Shashi

Re: IF and IsNull function

Anonymous — Mon, 05 Nov 2018 08:16:03 GMT

Same result as by using the other formula, but thanks for your help.

Re: IF and IsNull function

sasiparupudi1 — Mon, 05 Nov 2018 08:23:48 GMT

Please provide a sample app.

Re: IF and IsNull function

vishsaggi — Mon, 05 Nov 2018 16:40:36 GMT

Can you share exact expr you are trying to use in your app? With some sample data would help.