topic Re: Issues with TimeMeasurement in QlikView

Issues with TimeMeasurement

Fri, 14 Aug 2015 11:01:47 GMT

Hello,

It is my first time using this forum and I hope that my question will be clear enough.

As you can see on the table I have joined, I have 4 fields :

-Date

-Time

-Rack

-Reference

I have already managed to create a timestamp with my entries using the following:

Timestamp#(Date(Date)&' '& Time(Time),'MM/DD/YYYY hh:mm') as TMSTP

What I want to calculate is a duration for each reference : this duration should be the difference between the 1st time the reference is registered in the table and the 1st time the rack field is modified. As you can see on the attached table, all references are entered at first in a rack starting with 'A999**' Then the rack is modified and gets a different kind of number.
TO calculate this duration I have tried the following but it did not work :

Interval#(min({<Location-={'A999**'}>} TMSTP) - min (TMSTP))

The min(TMSPT) will always be the 1st entry of the reference in the table and the min({<Location-={'A999**'} TMSTP) is the st time the location is changed.

Do you guys have any idea to solve this one?

Thanks you very much
I wish you all a good day

Gilbert

Re: Issues with TimeMeasurement

MK_QSL — Fri, 14 Aug 2015 11:38:47 GMT

May be

Interval(Min(TOTAL <Reference> DateTime) - Min(DateTime),'hh:mm')

Interval(Min(DateTime) - Min(TOTAL <Reference> DateTime),'hh:mm')

Re: Issues with TimeMeasurement

sasiparupudi1 — Fri, 14 Aug 2015 11:56:38 GMT

Interval#(min({<Rack-={'A999*'}>} TMSTP) - min (TMSTP))

Re: Issues with TimeMeasurement

Kushal_Chawda — Fri, 14 Aug 2015 12:00:55 GMT

Please see the attached

Re: Issues with TimeMeasurement

Fri, 14 Aug 2015 12:21:46 GMT

Thank you for your answer but I dont have access to other qlikview files...
Could you write your code in a text file please?
Thank you very much again

Re: Issues with TimeMeasurement

Kushal_Chawda — Fri, 14 Aug 2015 12:30:25 GMT

Script is below,

Data:

LOAD Date,

timestamp(Date+Time,'DD-MM-YYYY hh:mm:ss') as TMPST,

Time,

Rack,

Reference

FROM

[Inner Movements.xlsx]

(ooxml, embedded labels, table is RHECMULC797);

In front end create straight table

Dimensions:

Reference,

TMPST

Expression:

=interval(aggr(min({<Rack-={'A999*'}>}TMPST)- min(TMPST), Reference),'hh:mm:ss')

Re: Issues with TimeMeasurement

sasiparupudi1 — Fri, 14 Aug 2015 12:34:58 GMT

try if this returns the correct timestamp

min({1<Location-={'A999*'} TMSTP)

Re: Issues with TimeMeasurement

Kushal_Chawda — Tue, 18 Aug 2015 07:34:36 GMT

Gilbert3D

are you able to resolve the issue?