{"id":41786,"date":"2018-11-14T17:37:15","date_gmt":"2018-11-14T12:07:15","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=41786"},"modified":"2018-11-14T17:37:15","modified_gmt":"2018-11-14T12:07:15","slug":"qlik-sense-time-zone-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/","title":{"rendered":"Qlik Sense Time Zone Function With Example"},"content":{"rendered":"

1. Objective<\/span><\/h2>\n

In our last Qlik Sense Tutorial, we discussed Qlik Sense In function<\/strong><\/a>. Today, we will see the Qlik Sense Time Zone Function. The functions explained below serves specifically in dealing with time zones of different countries. You can use these functions easily as a chart or script function.<\/span><\/p>\n

So, let’s start Qlik Sense Time Zone Function Tutorial.<\/p>\n

\"Qlik<\/a>

Qlik Sense Time Zone Function With Example<\/p><\/div>\n

Have a look at Qlik Sense Table Functions<\/strong><\/a><\/p>\n

2. Qlik Sense Time Zone Function<\/h2>\n

Following are the Qlik Sense Time Zone Function, let’s discuss them in detail –<\/p>\n

i. timezone() function<\/span><\/h3>\n

We use the Qlik Sense timezone() function to return the current time zone using the information provided by the system. Usually, in your system\u2019s details the time zone it operated on is stored. This function responds by returning a string data type. <\/span><\/p>\n

The syntax of Qlik Sense timezone function:<\/strong><\/p>\n

TimeZone()<\/pre>\n
For example, if you operate on a windows based system, in India, then upon using the TimeZone() function, you will get IST as the answer or result after script execution. <\/span><\/p>\n
ii. GMT() function<\/span><\/h3>\n
This function returns the current GMT which is Greenwich Mean Time, using the system\u2019s clock and windows time settings. The response is in dual data format that is both strings and integers are returned. <\/span><\/p>\n
The syntax of GMT Function in Qlik Sense:<\/strong><\/p>\n
gmt()<\/pre>\n
For example, if the current time according to GMT is 6:00, then using this function <\/span>gmt()<\/span> in the Qlik Sense script will return <\/span>GMT-6:00<\/span>. <\/span><\/p>\n
iii. UTC() function <\/span><\/h3>\n
The UTC function returns the Coordinated Universal Time, abbreviated as UTC. It returns a dual data type value, which has both the string and numeric interpretations of date and time according to UTC.<\/span><\/p>\n
Do you know about Qlik Sense Logical Functions<\/a><\/strong><\/p>\n
The syntax of Qlik sense UTC Function:<\/strong><\/p>\n
utc()<\/pre>\n
For example, if you right now enter the utc() function in the script, it will return the current UTC time and date. <\/span><\/p>\n
utc()<\/pre>\n
Returns, <\/span><\/p>\n
2018\/10\/26, 20:17:12-UTC<\/span> as the current UTC time. <\/span><\/p>\n
iv. daylightsaving() function<\/span><\/h3>\n
The daylight savings time is adjusting the clock a few hours forward or backward, depending upon how warm or cold the weather is because the duration of daylight varies depending on the weather. This function is used to return the current adjustments done in your system\u2019s clock for the daylight-saving phenomenon. However, it is not necessary and always that a country or region is experiencing such shifts. This function returns the value in dual data format. <\/span><\/p>\n
The syntax of daylightsaving function in Qlik Sense<\/strong>:<\/strong> <\/span><\/p>\n
daylightsaving()<\/pre>\n
v. converttolocaltime() function <\/span><\/h3>\n
This function is used when you want to convert a UTC or GMT to a local time zone of any region, place or country. This function returns a dual value that is both string and text representation. There are many countries which are considered as valid places and time zones to use this function on.<\/span><\/p>\n
Let’s revise Qlik Sense Mapping Functions<\/a><\/strong><\/p>\n
The syntax of Qlik Sense Converttolocaltime function:<\/strong><\/p>\n
ConvertToLocalTime(timestamp [,place [,ignore_dst=false]])<\/pre>\n
Where <\/span>timestamp<\/span><\/i> is the current recorded time (UTC or GMT) which will be converted into a local time zone. <\/span><\/p>\n
The <\/span>place<\/span><\/i> parameter specifies the place or even takes UTC or GMT values to evaluate the time and date accordingly. You can refer to any list online of valid places and time zones.<\/span><\/p>\n
The <\/span>ignore_dst=false <\/span><\/i>can be set to True if you want to ignore the Daylight savings time adjustment in your system. And if not, then set the ignore_dst parameter to False. <\/span><\/p>\n
For example,<\/span><\/p>\n
The expression, <\/span>ConvertToLocalTime(‘2007-11-10 23:59:00′,’Paris’)<\/span> will return <\/span>\u20192007-11-11 00:59:00\u2019<\/span> as it is for Paris at the given time. This will be stored as a timestamp in the memory. <\/span><\/p>\n
ConvertToLocalTime(UTC(),'GMT-05:00', True)<\/pre>\n
Returns,<\/span><\/p>\n
The local time for the North American east coast place like New York, without daylight-saving time adjustment.<\/span><\/p>\n
In the sample expression given above, UTC() is the current time in UTC which we want to convert into a local time zone. Where GMT-05:00 tells the time of the current time zone in GMT mode and the ignore_dst has been set to True which ignores the daylight savings time adjustments done by the system.<\/span><\/p>\n
You must read Qlik Sense Line Chart<\/a><\/strong><\/p>\n
So, this was all in Qlik Sense Time Zone Function. Hope you like our explanation.<\/p>\n
3. Conclusion <\/span><\/h2>\n
Hence, these were all the functions we use in handling timezone related issues. We can simply use functions like GMT, UTC, timezone, to see what time it is according to a specific time zone. Or, we can use daylightsaving and converttolocal functions which performs more complex calculations and returns corresponding values. Such functions are very convenient, easy to understand and apply in time zone related operations of the enterprise as in most cases the business spread at places around the globe.<\/span><\/p>\n
See also –\u00a0<\/strong><\/p>\n
Trigonometric and Hyperbolic Functions<\/a><\/strong><\/p>\n
Reference for Qlik Sense<\/a><\/strong>
1. Objective In our last Qlik Sense Tutorial, we discussed Qlik Sense In function. Today, we will see the Qlik Sense Time Zone Function. The functions explained below serves specifically in dealing with time...<\/p>\n","protected":false},"author":6,"featured_media":41824,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[17638,17639],"class_list":["post-41786","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-qlik-sense-time-zone-function","tag-time-zone-function-in-qlik-sense"],"yoast_head":"\nQlik Sense Time Zone Function With Example - DataFlair<\/title>\n<meta name=\"description\" content=\"Qlik Sense Time Zone Function - GMT Function, UTC Function, daylightsaving function, coverttolocaltime function in Qlik Sense\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Time Zone Function With Example - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Qlik Sense Time Zone Function - GMT Function, UTC Function, daylightsaving function, coverttolocaltime function in Qlik Sense\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-14T12:07:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Time-Zone-Function-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qlik Sense Time Zone Function With Example - DataFlair","description":"Qlik Sense Time Zone Function - GMT Function, UTC Function, daylightsaving function, coverttolocaltime function in Qlik Sense","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Time Zone Function With Example - DataFlair","og_description":"Qlik Sense Time Zone Function - GMT Function, UTC Function, daylightsaving function, coverttolocaltime function in Qlik Sense","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-14T12:07:15+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Time-Zone-Function-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Time Zone Function With Example","datePublished":"2018-11-14T12:07:15+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/"},"wordCount":805,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Time-Zone-Function-01.jpg","keywords":["Qlik Sense Time Zone Function","Time Zone Function in Qlik Sense"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/","name":"Qlik Sense Time Zone Function With Example - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Time-Zone-Function-01.jpg","datePublished":"2018-11-14T12:07:15+00:00","description":"Qlik Sense Time Zone Function - GMT Function, UTC Function, daylightsaving function, coverttolocaltime function in Qlik Sense","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Time-Zone-Function-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Time-Zone-Function-01.jpg","width":1200,"height":628,"caption":"Qlik Sense Time Zone Function With Example"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Qlik Sense Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlik-sense-tutorials\/"},{"@type":"ListItem","position":3,"name":"Qlik Sense Time Zone Function With Example"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/41786","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=41786"}],"version-history":[{"count":3,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/41786\/revisions"}],"predecessor-version":[{"id":42062,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/41786\/revisions\/42062"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/41824"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=41786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=41786"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=41786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}