Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Timezones in QlikView

Hi,

is it possible to handle Timezones in QlikView? For example the QlikView Server is based in the US and all the timestamps have the format of UTC. But now we have people from australia who works with that reports and there want to see the timestamp in AUS Timezone. Is there any function or something like that?

2 Replies
swuehl
MVP
MVP

There are functions to convert your UTC to local time:

ConvertToLocalTime(timestamp [, place [, ignore_dst=false]])

To set the place you may want your users set the place there are in using a variable. Or maybe you can get the place by user loading data from a user database.

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

ConvertToLocalTime should play the role.