25 May 2022 Adjust timezones in Qlik with ConvertToLocalTime() Share this message Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about converting timezones in Qlik: The correct answer is C: ConvertToLocalTime(PhoneCallTime, ‘Helsinki’) When extracting data from various sources, it is most likely that the server on which the data is stored runs on UTC time. This will mean that if any timestamps are stored they will be stored in UTC time as well. When this data is subsequently loaded without accounting for different time zones, differences between the stored timestamp and the actual time on which an action has happened may occur, as is the case in the example. Since the opening hours of the office are between 08:00 and 20:00 the majority of the phonecalls is to be expected to be between those hours. In the figure however, we can clearly see they start to early and end too soon. By using the following syntax we can solve this: ConvertToLocalTime(timestamp [, place [, ignore_dst=false]]) The first part of the syntax requires the timestamp which we would like to convert. In this case it was the field “PhoneCallTime”. The second part of the syntax is ‘Place‘ or rather the location we would like to convert to. So in the example we have used Helsinki. Hereby it is worth noting that Qlik retrieves its location information from the Windows Registry. You can find the whole list of locations and time zones at: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones Keep in mind however that this part of the syntax is sensitive to the language settings on the machine. Cities may have different spelling in different languages, so make sure hat the spelling used in the script matches the language settings of the machine. Daylight savings time. Standard this is set to False (0), but by setting this to True (1) you will be able to ignore DST if this is required. This is also the reason that answer D is wrong. While technically this might work, it does not account for DST. Helsinki and Johannesburg for example are both in the same timezone, UTC+2. However as we can see in this example, the current time for Helsinki is UTC+3 since Finland uses DST, while Johannesburg does not. So when using ConvertToLocalTime also keep in mind whether the location you are converting to is located on the northern or southern hemisphere to make sure this is also calculated correctly. That’s it for this week. See you next Friday? Want more? Then click the button below for our full archive! More Qlik test prep questions and answers Friday Qlik Test Prep Solution How can we help? Feel free to contact us if you have any comments or questions. Call us Mail us 27 December 2022 Calculating fractiles in Qlik Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about calculating fractiles in Qlik. It seems like a lot of you have spend a great time around Christmas, since we are normally used to more answers. […] Friday Qlik Test Prep Solution 21 December 2022 Sorting data in Qlik Sense Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about sorting data in Qlik Sense. Many responses again and as expected nobody was fooled by the answers. You all got it right! The correct answer is […] Friday Qlik Test Prep Qlik 14 December 2022 Using ApplyMap in Qlik Sense Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about using ApplyMap in Qlik Sense. Great to see so many responses and correct answers again. Luckily ApplyMap seems to be a very familiar function. The correct […] Friday Qlik Test Prep Solution
27 December 2022 Calculating fractiles in Qlik Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about calculating fractiles in Qlik. It seems like a lot of you have spend a great time around Christmas, since we are normally used to more answers. […] Friday Qlik Test Prep Solution
21 December 2022 Sorting data in Qlik Sense Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about sorting data in Qlik Sense. Many responses again and as expected nobody was fooled by the answers. You all got it right! The correct answer is […] Friday Qlik Test Prep Qlik
14 December 2022 Using ApplyMap in Qlik Sense Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about using ApplyMap in Qlik Sense. Great to see so many responses and correct answers again. Luckily ApplyMap seems to be a very familiar function. The correct […] Friday Qlik Test Prep Solution