topic Re: DateDiff in QlikView

DateDiff

Mon, 16 Nov 2015 16:25:37 GMT

Hi,

How can I change the following sql link in Qlikview:

Case WHEN DATEDIFF(MINUTE,[Arrival DateTime],[Departure DateTime]) > 240 THEN 1 ELSE 0 END [BREACH]

Thanks.

Re: DateDiff

sunny_talwar — Mon, 16 Nov 2015 16:35:23 GMT

May be this:

If((([Departure DateTime] - [Arrival DateTime]) * (24*60)) > 240, 1, 0)

Re: DateDiff

MarcoWedel — Mon, 16 Nov 2015 23:21:23 GMT

Hi,

one solution could be also:

-([Departure DateTime]-[Arrival DateTime]>'04:00') as BREACH

LOAD *,
     -([Departure DateTime]-[Arrival DateTime]>'04:00') as BREACH;
LOAD *,
     Timestamp([Arrival DateTime]+Rand()) as [Departure DateTime];
LOAD Timestamp(Today()+Rand()) as [Arrival DateTime]
AutoGenerate 30;

hope this helps

regards

Marco

Re: DateDiff

jagan — Tue, 17 Nov 2015 00:46:55 GMT

Hi,

YOu can try Interval() in Qlikview which is equivalent to DateDiff()

Example: If(Num(Interval([Departure DateTime] - [Arrival DateTime], 'm')) > 240, 1, 0) AS BREACH

Hope this helps you.

Regards,

Jagan.

Re: DateDiff

Tue, 17 Nov 2015 08:17:40 GMT

Thank you

Re: DateDiff

jagan — Tue, 17 Nov 2015 09:11:12 GMT

Hi,

If you got the answer please close this thread by giving Correct and Helpful answers to the posts which helps you.

Regards,

Jagan.