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: 
ShellyG
Creator
Creator

Time visual in different time zones

Hi there, 

I have a weird situation where I would like some help. 

I have a histogram created in Qlik Sense that is displaying the open tickets per hour. To display that, I use the 'created time' field of the tickets that I have converted in hours. So basically the x-axis of the chart will look like the screenshot in the attachments. 

My question now is the following - the 'created time' field that I use contains time in different time zones, so how can I make sure that the users will be looking at their desired timezone for all tickets? 

PS I tried creating an inline table with different time zones and then add them as buttons, but this solution doesn't work for me as it will show only the tickets that have that time zone in their 'created time'. What I want to accomplish is view ALL tickets in different time zones...

Your thoughts are appreciated! 

BR,

Shelly 

Labels (2)
1 Solution

Accepted Solutions
fosuzuki
Partner - Specialist III
Partner - Specialist III

Hi Shelly,

I think you can solve it in two parts:

1. When getting the data from the sources, convert all the timestamps to UTC time

2. When using the timestamps in the visualizations, use the ConvertToLocalTime function

View solution in original post

1 Reply
fosuzuki
Partner - Specialist III
Partner - Specialist III

Hi Shelly,

I think you can solve it in two parts:

1. When getting the data from the sources, convert all the timestamps to UTC time

2. When using the timestamps in the visualizations, use the ConvertToLocalTime function