topic Re: Timestamp duration wise in QlikView

Timestamp duration wise

Sat, 13 Jul 2013 13:35:23 GMT

hi all..

Please help me resolve the following problem:

if we have a timesheet foe a company and organizations want to see sum of logged hours on timestamp duration wise for complete organization. durations are full day, 4 hours, 2 hours, 1 hour, 30 minutes.

user will change these on the fly. logged hour data should change accordingly also specify time corresponding to that time.

Re: Timestamp duration wise

CELAMBARASAN — Sat, 13 Jul 2013 13:37:29 GMT

How the data looks like and in which format?

Re: Timestamp duration wise

Sat, 13 Jul 2013 13:44:37 GMT

for example choosing 1 hour duration by the user, data should like like..

TIME LOGGED_HOURS

9-10 200

10-11 150

11-12 300

Re: Timestamp duration wise

CELAMBARASAN — Sat, 13 Jul 2013 17:11:21 GMT

Hi,

You have to do it in load script where you can derive this timelines. Can you upload sample file.

I still didn't how your raw data looks like.