How to get avg - from date difference (mins)

ashmitp869 — Thu, 02 Feb 2023 23:49:21 GMT

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]

Re: How to get avg - from date difference (mins)

henrikalmen — Tue, 14 Feb 2023 13:37:59 GMT

Yes.

topic Re: How to get avg - from date difference (mins) in App Development

How to get avg - from date difference (mins)

Re: How to get avg - from date difference (mins)