topic IF in script in order to replacing zero values into time in QlikView

IF in script in order to replacing zero values into time

Sun, 20 May 2012 14:23:12 GMT

Hi All,

Why is this expression

if( IsNull(OPNTIJD)=0,OPNTIJD,0.33333)

working well as normal expression but not working when i do this in the script

as below.

LOAD

OPNDAT,

OPNTIJD,

if( IsNull(OPNTIJD)=0,OPNTIJD,0.33333) as ADMDAT

Resident BEDOCUP;

My goal is to replace zero value´s into 08:00 hour preferable is to do this in the script.

THANKS IN ADVACE!!

Jason_Michaelides — Sun, 20 May 2012 16:38:00 GMT

Are the values to change definitely Nulls and not zeros?

Sun, 20 May 2012 17:03:06 GMT

please try this script

if(len(trim(OPNTIJD))=0,0.33333,OPNTIJD) as OPNTIJD

Sun, 20 May 2012 19:34:48 GMT

Yes absolutly nulls and not zero's

Sun, 20 May 2012 19:46:37 GMT

No unfortunatly ït is not working

masha-ecraft — Mon, 21 May 2012 06:33:10 GMT

Try this:

LOAD

OPNDAT,

OPNTIJD,

if( IsNull(OPNTIJD), 0.33333, OPNTIJD) as ADMDAT

Resident BEDOCUP

Jason_Michaelides — Mon, 21 May 2012 06:55:55 GMT

Masha's right - you're IsNull() is reversed! 0=False, -1 or nothing = True.

Mon, 21 May 2012 07:32:03 GMT

THANKS THIS WORKS WELL