topic Re: Get Date and Time based on User Login Zone in QlikView

Get Date and Time based on User Login Zone

Thu, 14 May 2015 16:28:43 GMT

Hi Team,

Is it possible to get date and time dynamically based on user login time zone.

For example: CST or EST then the corresponding values need to be displayed.

Thanks,

Sai

Re: Get Date and Time based on User Login Zone

Clever_Anjos — Thu, 14 May 2015 16:31:41 GMT

LocalTime([timezone [, ignoreDST ]])

Returns a timestamp of the current time from the system clock for a specified time zone. The timezone is specified as a string containing any of the geographical places listed under Time Zone in the Windows Control Panel for Date and Time or as a string in the form 'GMT+hh:mm' or 'UTC+hh:mm'. If no timezone is specified the local time will be returned. If ignoreDST is -1 (true) daylight savings time will be ignored.

Examples:

localtime ('Paris')

localtime ('GMT+01:00')

localtime ('Paris',-1)

localtime()

Re: Get Date and Time based on User Login Zone

Thu, 14 May 2015 16:36:56 GMT

Hi Clever,

Thanks so much for the response. Will the localtime return the timestamp from QlikView Server or the user logged in system time?

Is there a way to detect dynamically the timezone when user logs in. For example:

A user logs in from Chicago, another user logs in from Newyork. How do we detect this dynamically based on user logins?

Thanks,

sai

Re: Get Date and Time based on User Login Zone

buzzy996 — Thu, 14 May 2015 16:43:34 GMT

may be, u can go with governance dashboard,tht helps here.

Re: Get Date and Time based on User Login Zone

Thu, 14 May 2015 16:45:12 GMT

Hi Shiva,

Can you please share the document, I am missing in my samples and the steps to find them

Thanks so much for your help

Thanks,

sai

Re: Get Date and Time based on User Login Zone

Anonymous — Thu, 14 May 2015 16:52:48 GMT

I had a similar problem, except I was trying to get date format:

User-specific date format

n your case it will be local time zone. I assume you can use a similar approach.

Re: Get Date and Time based on User Login Zone

buzzy996 — Fri, 15 May 2015 08:48:33 GMT

u can login to qlikview partner portal(not community) and download the same.