Using Coalesce

[neerajthakur]

Hi, I want to calculate time difference in hours and try to convert an SQL Logic to use in Qlik Sense

SQL:

DATEDIFF(minute,convert(datetime,RECEIVEDON,104),COALESCE(CONVERT(datetime,SUpdatedOn,104),CONVERT(datetime,SDATE,104)))/60

My statement in QlikSense:

(Coalesce(Date(SUpdatedOn),Date([SDATE]))-(Date([RECEIVEDON])))/60 as Time_Taken

On doing: Date([SDATE]))-(Date([RECEIVEDON]))/60 as Time_Taken, I am getting value same as in manual calculation

I am getting different values than manual calculation on using this, If I don't use coalesce value is same. Let me know how can I correct it or some other way to achieve this.

@Suraj @Anonymous @Anonymous 

[Suraj]

Hi  Xlitzdrama,

Can you post some sample data with required output.