Reconstructing a code

datanibbler — Mon, 28 Jul 2014 08:08:23 GMT

Hi,

I am trying to reconstruct the working of a code that has been written by a colleague of mine and a consultant over a year ago.

(yes, this is the same issue as in my prior thread "Please tell me what this code does" where I already got some valuable help.

Now it's time to get hands_on, I just ran the code and here is the first riddle:

- The autogenerate-code (in the old version) obviously generates minute_intervals from 5:20am to 10:30pm, which is the total duration
of one working day

<=> Acc. to the log, there are 1711 records. Acc. to my calculator, there are 1710 minutes between those times - ok, the (+1) is
mathematically necessary), but when i do a simple COUNT() of these minute_intervals, there are only 1031??

Can you tell me why this is?

Now I have introduced a RESIDENT LOAD and a Line_ID, and there are 1711 line_IDs just as it should be - and it's in 24h-format, so there are no duplicate timestamps.

I'll try to find out with a tablebox.

Thanks a lot!

Best regards,

DataNibbler

Re: Reconstructing a code

datanibbler — Mon, 28 Jul 2014 08:24:13 GMT

Ah, ok, that was my error - the code only counts from 1 to 60 - so it does generate "real" minutes.

That is the difference.

topic Reconstructing a code in QlikView

Reconstructing a code

Re: Reconstructing a code