topic Re: if(value=x,NULL,value) in QlikView

if(value=x,NULL,value)

Mon, 06 Jul 2015 18:11:13 GMT

If a value is = to a certain value, then I need to set it to null, otherwise, I need to set it to the value.

What I'm not sure of, is what to use to set a value to null. Is '' truly a null value, or is there a way as there is in sql to say NULL, as '' is a blank string, not a null value.

Hopefully, this makes sense and I'm just having a moment.

Thanks in advance for your assistance!

Greg

Re: if(value=x,NULL,value)

marcus_sommer — Mon, 06 Jul 2015 19:01:33 GMT

You could simply use null():

if(value = 'x', null(), value)

- Marcus

Re: if(value=x,NULL,value)

sasiparupudi1 — Mon, 06 Jul 2015 19:20:01 GMT

"" is a blank string and Null() function returns the true null value. below is the help text from Qlik

Null( )

Returns a real NULL value.

Re: if(value=x,NULL,value)

MarcoWedel — Mon, 06 Jul 2015 20:50:20 GMT

Hi,

besides using the null() function, you could also negate your condition and omit the else part (so if() returns null in the else case):

If(value <> 'x', value)

hope this helps

regards

Marco

Re: if(value=x,NULL,value)

sasiparupudi1 — Wed, 08 Jul 2015 06:51:58 GMT

Please close this thread if you got your answer

Re: if(value=x,NULL,value)

Wed, 08 Jul 2015 18:27:06 GMT

Hi Sasidhar,

The only option in Actionss that I have is "Mark as Helpful." I'm definitely missing something simple. How do I "close the thread?"

Thanks!

Greg

Re: if(value=x,NULL,value)

MarcoWedel — Wed, 08 Jul 2015 19:00:13 GMT

you should see a correct answer button.

regards

Marco

Re: if(value=x,NULL,value)

MarcoWedel — Wed, 08 Jul 2015 19:23:43 GMT

Re: if(value=x,NULL,value)

Tue, 14 Jul 2015 15:01:20 GMT

I was looking at the thread in My Inbox, and the Correct Answer option wasn't displaying there. Opening it in a new tab, made it display.

Thanks!