topic Re: How to Calculate the difference between timestamp in hrs. in QlikView

How to Calculate the difference between timestamp in hrs.

Tue, 17 Dec 2013 07:08:14 GMT

Hi All,

How to Calculate the difference between timestamp in hrs. when my table is in the form of

CaseId PriorityId StageId Time

1 1 1 1/1/2013 11:08:00 AM

1 1 2 1/1/2013 11:20:00 AM

1 1 3 1/1/2013 12:20:00 AM

Now i need to make a chart where my dimension is a drill down of PriorityId and StageId and in expression i need to calculate the StageId wise expression,

Like for stage Id =1 then in expression the difference between Time of stageId 2 and Time of StageId 1.

and for stage Id =2 then in expression the difference between Time of stageId 3 and Time of StageId 2.

Thanks and Regards.

Re: How to Calculate the difference between timestamp in hrs.

jagan — Tue, 17 Dec 2013 07:20:50 GMT

Hi,

Try this script

Temp:

LOAD

CaseId,

PriorityId,

StageId,

Timestamp(Timestamp#(Time, 'M/D/YYYY hh:mm:ss TT'), 'M/D/YYYY hh:mm:ss TT') AS Time

INLINE [

CaseId, PriorityId, StageId, Time

1,1,1,1/1/2013 11:08:00 AM

1,1,2,1/1/2013 11:20:00 AM

1,1,3,1/1/2013 12:20:00 AM ];

Data:

LOAD

CaseId, PriorityId, StageId,

Time,

Interval(Previous(Time) - Time, 'hh') AS Hours

RESIDENT Temp

ORDER BY StageId Desc;

DROP TABLE Temp;

Regards,

Jagan.

Re: How to Calculate the difference between timestamp in hrs.

Tue, 17 Dec 2013 07:40:54 GMT

Hi Jagan,

Don't you think that calculation of hours is

Interval(Time - Previous(Time) , 'hh') AS Hours

instead of

Interval(Previous(Time) - Time, 'hh') AS Hours.