topic Re: generating the flag is not working in App Development

generating the flag is not working

ashmitp869 — Wed, 30 Nov 2022 23:10:34 GMT

Hi there,

please assist with the below script :

The variable flag is not calculation. Its always going to 0 that is else part.

Table:

LOAD

Interval([Departure DateTime] - [Arrival DateTime], 'hh')as [ED_LOS_HOURS],
if(Interval([Departure DateTime] - [Arrival DateTime], 'hh')>='06',1,0)as [ED LOS > 6 (Hours) Flag]

FROM

[$(vL.QVDPath)\QVD \Table.qvd]
(qvd)

Re: generating the flag is not working

vinieme12 — Thu, 01 Dec 2022 02:50:17 GMT

try below

if(Interval([Departure DateTime] - [Arrival DateTime], 'hh')>= INTERVAL(6,'hh'),1,0)as [ED LOS > 6 (Hours) Flag]

Re: generating the flag is not working

marcus_sommer — Thu, 01 Dec 2022 08:49:55 GMT

The interval() stuff isn't really necessary because you could query the result directly, like:

if([Departure DateTime] - [Arrival DateTime] >= 0.25, 1, 0) as [ED LOS > 6 (Hours) Flag]

- Marcus