Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.