Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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