topic Re: Converting timestamps to user time zone in QlikView

Converting timestamps to user time zone

anatezra — Sun, 06 Mar 2016 12:47:53 GMT

I've been searching the community for hours and I don't seem to find the answer..

How can I display to the users the time fields in their time zone?

In the Regedit the timezone information is under local machine and not current user so that's doesn't seem to work...

I'm using Sense but I guess it's the same for QV and Sense.

Thanks!

Re: Converting timestamps to user time zone

ashfaq_haseeb — Sun, 06 Mar 2016 13:34:09 GMT

HI,

I would add additional fields for all expected timezone and provide a cycle group over all time zone fields as dimension.

By this user can switch the required time zone. Or it could be a drop down selection for timezone selection.

Regards

ASHFAQ

Re: Converting timestamps to user time zone

anatezra — Sun, 06 Mar 2016 13:36:59 GMT

Thanks, but the users want to see it automatically..

Any ideas?

Re: Converting timestamps to user time zone

Anonymous — Sun, 06 Mar 2016 13:44:58 GMT

The only way I have managed to do this is by manually creating a lookup table of AD User vs. their time zone.

It would be great if there was a way of getting the time zone of the client machine but I have never found a way of doing this. I'd love to hear if anybody knows how to do this.

Re: Converting timestamps to user time zone

swuehl — Sun, 06 Mar 2016 14:07:19 GMT

As far as I know, there is no standard way to achieve this in QV / QS (i.e. some supported QV function).

But you may create an extension that supports this, maybe using one of the approaches for timezone detection discussed e.g. here:

http://stackoverflow.com/questions/13/determining-a-web-users-time-zone