topic help in qlikvie script - where date dif is use in App Development

help in qlikvie script - where date dif is use

ashmitp869 — Tue, 06 Dec 2022 05:35:22 GMT

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

Re: help in qlikvie script - where date dif is use

vinieme12 — Tue, 06 Dec 2022 07:08:59 GMT

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;

Re: help in qlikvie script - where date dif is use

ashmitp869 — Wed, 07 Dec 2022 23:38:41 GMT

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 .?

Re: help in qlikvie script - where date dif is use

vinieme12 — Wed, 07 Dec 2022 23:52:49 GMT

My bad, replace null with null()