topic Re: Convert Time Bucket to Local Time in QlikView

Convert Time Bucket to Local Time

krishna20 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

I have a time bucket in my table and it's starting from '00:00',it is in GMT. I need to convert this time bucket as to Local time (US).

Below is my code and output look like below . When i am using ConvertToLocalTime, its not working converting as expected.

Can anyone advise me on this issue.

The range could starts from 07:00- 07-30.

Time_Bucket:

load *,time(SubField((event_Buckets),'<=',1),'hh:mm') &' - '&

time(SubField((event_Buckets),'<',3),'hh:mm') as Event_Range;

LOAD EventDate,

%StateKey ,

class(frac(ConvertToLocalTime(TimeStamp)),1/48) as event_Buckets,

ConvertToLocalTime(TimeStamp) as TimeStamp ,

ConvertToLocalTime(eventdatetime) as eventdatetime,

from [$(File)](QVD);

Thanks

Krishna

krishna20 — Fri, 16 Feb 2018 07:47:24 GMT

Hi ,

Can anyone look into this issue.

shiveshsingh — Fri, 16 Feb 2018 10:17:50 GMT

Is this not working?

ConvertToLocalTime(FieldName, 'EST')

avinashelite — Fri, 16 Feb 2018 13:15:39 GMT

If your time is in GMT then try like this , otherwise you need convert the time to GMT or UTC first and then use the formula

ConvertToLocalTime(TimeStamp,'Central Time (US &Canada)')