Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
jelly_gvm
Creator
Creator

Display End User local time zone in the access point Dashboard

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

13 Replies
ashwanin
Specialist
Specialist

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

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
aveeeeeee7en
Specialist III
Specialist III

hariprasadqv
Creator III
Creator III

Hi,

Use converttolocaltime function.

Thanks

jelly_gvm
Creator
Creator
Author

There will be multiple locations....

jelly_gvm
Creator
Creator
Author

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

jelly_gvm
Creator
Creator
Author

Hi  Hari,

Can you give me any example for that ?

Thanks & Regards,

Ram

aveeeeeee7en
Specialist III
Specialist III

Use this:

ConvertToLocalTime([Start Time], 'UTC')

OR,

ConvertToLocal([TimeTimeField], 'UTC')

Regards

Av7eN

jelly_gvm
Creator
Creator
Author

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