topic Re: How to generate Start Time in QlikView

How to generate Start Time

alvinford — Tue, 05 Mar 2013 08:54:58 GMT

Hi All,

Facing issue with the time. Need to generate the start time based on the end time and duration.

I have event end time as 00:20:00 (hh:mm:ss) and Duration as 3:20:00(hh:mm:ss).

How can I get the Start Time i.e 09:00:00.

Request your help.

Thanks in Advance.

Regards,

Alvin.

Re: How to generate Start Time

Gysbert_Wassenaar — Tue, 05 Mar 2013 08:59:26 GMT

EndTime - Duration should give you the start time, 21:00:00 (or 09:00:00 PM) in your case, not 09:20:00. Make sure you work with dates and times, not strings. Use the date# and time# functions if necessary to create dates and times from strings.

Re: How to generate Start Time

er_mohit — Tue, 05 Mar 2013 09:03:09 GMT

hiii...

Interval(time(endtime,'hh:mm:ss')-Time(Duration,'hh:mm:ss'),'hh:mm:ss') as Start_Time

Re: How to generate Start Time

Tue, 05 Mar 2013 09:33:00 GMT

= interval (Time(Time#('12:20:00','hh:mm:ss')) - interval(Time(Time#('3:20:00','hh:mm:ss'))-Time(Time#('0:20:00','hh:mm:ss')),'hh:mm:ss'),'hh:mm:ss')

Bold - Specify hr's format. If you use 12hr Format Specify 12, else 24.

Hope this helps

Re: How to generate Start Time

alvinford — Tue, 05 Mar 2013 10:06:59 GMT

Thanks Gisbert I have rectified the output value.

Regards,

Alvin.

Re: How to generate Start Time

alvinford — Tue, 05 Mar 2013 10:08:12 GMT

Hi Mohit,

Its not giving the desired results.

Regards,

Alvin.

Re: How to generate Start Time

alvinford — Tue, 05 Mar 2013 10:16:09 GMT

Hi Streak,

I can't catch up your logic. I have added the sample data in the Excel with columns EndTime and Duration. Can you please help to achieve StartTime.

Please find the attachment.

Regards,

Alvin.

Re: How to generate Start Time

Tue, 05 Mar 2013 10:18:38 GMT

Copy the expression and put inside the text object, you will see what your

are expecting.

Re: How to generate Start Time

alvinford — Tue, 05 Mar 2013 12:38:37 GMT

Hi Streak,

I have already verified that.Can't get the expected values.

Regards,

Alvin.

Re: How to generate Start Time

alvinford — Tue, 05 Mar 2013 15:35:44 GMT

Can you please help ...

Regards,

Alvin.

Re: How to generate Start Time

Gysbert_Wassenaar — Tue, 05 Mar 2013 15:54:54 GMT

See attached qvw

Re: How to generate Start Time

alvinford — Tue, 12 Mar 2013 12:44:55 GMT

Hi Gysbert,

Thanks for your reply. I need more help on this.

LoginTime	LogOutTime
10:09:08 AM	10:18:20
10:13:54 AM	10:34:26
10:18:46 AM	12:19:18
10:22:06 AM	11:06:49
10:32:54 AM	16:15:54
10:44:11 AM	13:12:11
10:45:23 AM	13:14:49
10:48:58 AM	12:37:48
10:52:21 AM	12:39:28
10:58:15 AM	11:03:14
10:59:52 AM	11:24:11
10:59:57 AM	11:49:22

I have the LoginTime and LogoutTime need to Generate the Hours between the time in the New Column.

For Example : Taking the highlighted LoginTime and LogOut time i.e. 10:45:23 to 13:14:49 , Need to generate following hours between them i.e. 10,11,12,13 .

How can I generate new column containing Hours between the LoginTime and LogOut time ?

Regards,

Alvin.