topic Re: Display End User local time zone in the access point Dashboard in QlikView

Display End User local time zone in the access point Dashboard

jelly_gvm — Wed, 24 Jun 2015 05:48:25 GMT

Hello Team,

Could please provide me any idea about the TimeZone to display based on the End User location.

For an example if the Qlikview server (QMC) is in USA and the end user accessing that server object ( Dasboard ) in Singapore, so in this case we need to display the local timezone based on the user location ( like Universal ).

Its possible in qlikview ? or Any solution would helpfull for me.

Thanks in Advance.

Regards,

Ram

Re: Display End User local time zone in the access point Dashboard

ashwanin — Wed, 24 Jun 2015 05:56:45 GMT

End users only belongs to Singapore or you have multiple time zones?

Re: Display End User local time zone in the access point Dashboard

jonathandienst — Wed, 24 Jun 2015 06:01:15 GMT

Its possible, but your data source will need to have the timezone or country as a field.

Re: Display End User local time zone in the access point Dashboard

aveeeeeee7en — Wed, 24 Jun 2015 06:11:25 GMT

See this:

Re: how to convert a local time to utc time when I have the time zone?

Regards

Av7eN

Re: Display End User local time zone in the access point Dashboard

hariprasadqv — Wed, 24 Jun 2015 06:21:12 GMT

Hi,

Use converttolocaltime function.

Thanks

Re: Display End User local time zone in the access point Dashboard

jelly_gvm — Wed, 24 Jun 2015 07:29:35 GMT

There will be multiple locations....

Re: Display End User local time zone in the access point Dashboard

jelly_gvm — Wed, 24 Jun 2015 07:32:15 GMT

Hi Jonathan,

There is no such fields in the tables, Based on the Last reload time i need to the display the End user local time zone.

Can you share any link for this issue.

Thanks in advance.

Regards,

Ram

Re: Display End User local time zone in the access point Dashboard

jelly_gvm — Wed, 24 Jun 2015 07:33:54 GMT

Hi Hari,

Can you give me any example for that ?

Thanks & Regards,

Ram

Re: Display End User local time zone in the access point Dashboard

aveeeeeee7en — Wed, 24 Jun 2015 07:36:13 GMT

Use this:

ConvertToLocalTime([Start Time], 'UTC')

OR,

ConvertToLocal([TimeTimeField], 'UTC')

Regards

Av7eN

Re: Display End User local time zone in the access point Dashboard

jelly_gvm — Wed, 24 Jun 2015 07:53:02 GMT

Hi Av7en,

In QV access point it should convert time zone to the end user local time zone, its possible in qlikview ?

Can you suggest me.

Thanks & Regards,

Ram

Re: Display End User local time zone in the access point Dashboard

vardhancse — Wed, 24 Jun 2015 09:10:27 GMT

Hi,

In general qlikview accesspoint will show the server time zone only.

If we want to show the user time zone then in additional objects we need to use converttolocal() to know the user local time zone

Re: Display End User local time zone in the access point Dashboard

jelly_gvm — Wed, 24 Jun 2015 09:47:18 GMT

Can you share any QVW, if you have tested it early, It will really helfull for me.

I have used ConverToLocalTime(Reload()) function in TextBox and also deployed in the Access Point ( Note:- My server in USA and I'm accessing in India ), but there is no change in the time zone.

Re: Display End User local time zone in the access point Dashboard

jonathandienst — Wed, 24 Jun 2015 09:48:34 GMT

So how do you expect to set the local time if you dont know which time zone the user is in?

Re: Display End User local time zone in the access point Dashboard

jelly_gvm — Wed, 24 Jun 2015 09:56:54 GMT

there is no specific time zone is given to me,

Can you share me your file which you have tested earlier that would helpfull for me ( Like if the Country name and Timezone field are there in the Tables )

I've used the below function for convertion, but there no change in it.

ConverToLocalTime(Reload())