topic Re: Flag for time difference in QlikView

Flag for time difference

Wed, 16 Apr 2014 16:59:36 GMT

Hello All,

I have the data for flight arrivals and departures and from that data i want to get difference and if difference is 0 then flag Zero Difference to be added. How comes this situation please help.

Depart	Arrive	Difference
00:02:00	00:03:00	00:01:00
00:02:00	00:02:00	Zero Diff
00:02:00	00:05:00	00:03:00
00:02:00	00:02:00	Zero Diff
00:02:00	00:05:00	00:03:00
00:02:00	00:04:00	00:02:00
00:02:00	00:02:00	00:00:00

diff = arrive - depart

Oh I updated now please check

Thanks

Re: Flag for time difference

swuehl — Wed, 16 Apr 2014 17:13:11 GMT

Sorry, I don't fully understand. You get 'Zero Diff' even when the difference is apparently not zero?

Please post the expression you are using or the script code.

Re: Flag for time difference

its_anandrjs — Wed, 16 Apr 2014 17:31:43 GMT

Your data is not proper or may be you asking difference of arrive and depart so do like

if( (Time(Arrive,'hh:mm:ss') - Time(Depart,'hh:mm:ss') ) ='00:00:00','Zero diff', Time(Time(Arrive,'hh:mm:ss') - Time(Depart,'hh:mm:ss'))) as Diff

Re: Flag for time difference

Wed, 16 Apr 2014 17:34:58 GMT

Yes you are right please check now i am updated the data.

Thanks

Re: Flag for time difference

MK_QSL — Wed, 16 Apr 2014 19:31:22 GMT

Check enclosed file...

Re: Flag for time difference

Wed, 16 Apr 2014 20:29:08 GMT

Manish i am using personal edition so i am not able to open your file please provide me script.

Re: Flag for time difference

its_anandrjs — Wed, 16 Apr 2014 20:32:45 GMT

You can load like

Temp:

LOAD *,RecNo() as Rowid;

LOAD * INLINE [

Depart, Arrive, Difference

00:02:00, 00:03:00, 00:01:00

00:02:00, 00:02:00, Zero Diff

00:02:00, 00:05:00, 00:03:00

00:02:00, 00:02:00, Zero Diff

00:02:00, 00:05:00, 00:03:00

00:02:00, 00:04:00, 00:02:00

00:02:00, 00:02:00, 00:00:00

];

LOAD *,

if(Time#(Arrive,'hh:mm:ss') - Time#(Depart,'hh:mm:ss') ='00:00:00','Zero diff',Time(Time#(Arrive,'hh:mm:ss') - Time#(Depart,'hh:mm:ss'))) as Diff,

Resident Temp;

DROP Table Temp;

Re: Flag for time difference

MK_QSL — Thu, 17 Apr 2014 05:47:00 GMT

Script.

==========

Load

RowNo() as NO,

Time#(Depart,'hh:mm:ss') as Depart,

Time#(Arrive,'hh:mm:ss') as Arrive,

IF(Time#(Arrive,'hh:mm:ss')-Time#(Depart,'hh:mm:ss')='00:00:00','No Diff',Time(Time#(Arrive,'hh:mm:ss')-Time#(Depart,'hh:mm:ss'))) as Difference,

IF(Interval(Arrive-Depart,'hh:mm:ss')='00:00:00','No Diff',Interval(Arrive-Depart,'hh:mm:ss')) as Flag

Inline

[

Depart, Arrive

00:02:00, 00:03:00

00:02:00, 00:02:00

00:02:00, 00:05:00

00:02:00, 00:02:00

00:02:00, 00:05:00

00:02:00, 00:04:00

00:02:00, 00:02:00

];

===================

Re: Flag for time difference

Thu, 17 Apr 2014 09:03:54 GMT

Thanks Anand and Manish both answers are correct thanks once again to you all.