help in qlikvie script - where date dif is use

[ashmitp869]

Hi there ,

please assist with the qlikview script :

view:
Load
[Key],
iif((DATEDIFF(minute,[checkin_dt],[Doctor Seen DateTime]) >=0 and ([DecisionToAdmit] is not null)),DATEDIFF(minute,[checkin_dt],[Doctor Seen DateTime]),null) as [Presentation to Doctor (Minutes)]
resident tmp;

Hw to write it in Qlikview load script

[vinieme12 · Accepted solution]

view:
Load
[Key],
if( NUM(INTERVAL([checkin_dt]-[Doctor Seen DateTime] ,'mm' ))>=0 and NOT ISNULL([DecisionToAdmit]) , NUM(INTERVAL([checkin_dt]-[Doctor Seen DateTime] ,'mm' )), null) as [Presentation to Doctor (Minutes)]
resident tmp;

[ashmitp869]

Hi Vineeth,

As I have null value in the field - I am getting the below error -( attached img.PNG)

Is there any way to handle this in script .?

[vinieme12]

My bad,  replace null with null()