How to get avg - from date difference (mins)

[ashmitp869]

Hi ,

I have create in sql db to get the diff of two dates in minuutes like below -

select

iif((DATEDIFF(minute,[SUB_EVNT_FIRST_DECISION_FORMALLY_ADMIT_DTTM],[CL_DEPART_DTTM]) >=0 and ([SUB_EVNT_FIRST_DECISION_FORMALLY_ADMIT_DTTM] is not null)),DATEDIFF(minute,[SUB_EVNT_FIRST_DECISION_FORMALLY_ADMIT_DTTM],[CL_DEPART_DTTM]),null) as Admitted_Minutes_From_Bed_Ready_To_Transfer

from table

Now , in qlikview - how to get the avg of that field ?

Am I doing this correct in qlikview expression  by using the Avg() ?

Avg([Admitted_Minutes_From_Bed_Ready_To_Transfer]

[henrikalmen · Accepted solution]

Yes.