{"id":41791,"date":"2018-11-14T17:39:11","date_gmt":"2018-11-14T12:09:11","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=41791"},"modified":"2018-11-14T17:39:11","modified_gmt":"2018-11-14T12:09:11","slug":"qlik-sense-integer-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/","title":{"rendered":"Qlik Sense Integer Functions of Time With Syntax"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:1641,&quot;href&quot;:&quot;https:\\\/\\\/www.qlik.com\\\/us\\\/products\\\/qlik-sense&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20250910054814\\\/https:\\\/\\\/www.qlik.com\\\/us\\\/products\\\/qlik-sense&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-09 14:59:04&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-12 19:36:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-16 00:14:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-19 05:16:53&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-22 07:28:18&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-25 14:15:00&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-29 02:13:23&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-01 05:49:02&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-04 07:22:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-07 08:15:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-11 13:51:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-14 16:21:34&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-19 02:44:56&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-22 03:03:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-25 11:06:55&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-28 12:37:56&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-01 00:15:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-04 05:47:54&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-07 12:47:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-10 15:45:46&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-13 17:01:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-16 17:50:31&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-20 06:42:11&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-23 09:55:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-26 10:25:41&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-01 16:39:38&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-05 05:06:15&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-08 11:22:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-11 13:38:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-14 19:24:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-18 01:36:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-21 23:13:54&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-25 01:59:39&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-29 13:02:13&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-01 13:05:32&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-04 14:23:51&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-07 17:56:15&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-10 21:58:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-14 04:26:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-17 06:08:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-20 07:37:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-23 09:28:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-27 07:37:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-30 08:39:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-04 07:49:58&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-07 09:05:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-10 12:55:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-13 15:31:27&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-17 20:04:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-21 03:24:04&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-25 05:12:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-28 09:09:10&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-01 06:19:49&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-01 06:19:49&quot;,&quot;http_code&quot;:206},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<h2><span style=\"font-weight: 400\">1. Objective<\/span><\/h2>\n<p><span style=\"font-weight: 400\">In our last Qlik Sense Tutorial, we discussed <a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/\"><strong>Qlik Sense Time Zone Functions<\/strong><\/a>. Today we will see Qlik Sense Integer Functions of Time. The integer functions of time are used to evaluate time and return the resultant value as integers. Moreover, we will discuss Qlik Sense Integer Functions of Time with the help of example and syntax.<\/span><\/p>\n<p>So, let&#8217;s start Qlik Sense Integer Functions tutorial.<\/p>\n<div id=\"attachment_41822\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Integer-Functions-of-Time-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-41822\" class=\"size-full wp-image-41822\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Integer-Functions-of-Time-01.jpg\" alt=\"Qlik Sense Integer Functions\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Integer-Functions-of-Time-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Integer-Functions-of-Time-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Integer-Functions-of-Time-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Integer-Functions-of-Time-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Integer-Functions-of-Time-01-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Integer-Functions-of-Time-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-41822\" class=\"wp-caption-text\">Qlik Sense Integer Functions of Time With Syntax<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/\">Have a look at Qlik Sense Logical Functions<\/a><\/strong><\/p>\n<h2>2. Qlik Sense Integer Functions<\/h2>\n<p>Following are some Qlik Sense Integer Functions, let&#8217;s discuss them in detail &#8211;<\/p>\n<h3><span style=\"font-weight: 400\">i. second() function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">The second() function returns seconds from the timestamp as an integer value. The timestamp is an expression which punches the current time and present date in the system\u2019s memory. <\/span><\/p>\n<p><strong>The syntax of Qlik Sense second function:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">second(expression)<\/pre>\n<p><span style=\"font-weight: 400\">Where expression is the time in standard number interpretation.<\/span><\/p>\n<p><span style=\"font-weight: 400\">For example,<\/span><\/p>\n<p><span style=\"font-weight: 400\">The expression, <\/span><span style=\"font-weight: 400\">second(&#8217;09:30:36&#8242;)<\/span><span style=\"font-weight: 400\"> will return 36 as it is the value of seconds on the given time. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Also, if you give time in a function as, <\/span><span style=\"font-weight: 400\">second(&#8216;5: 14: 0.5555&#8217;)<\/span><span style=\"font-weight: 400\"> then the function will return 55 ( Because 0.5555 = 5:14:55 as per the standard time interpretation).<\/span><\/p>\n<h3><span style=\"font-weight: 400\">ii. minute() function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">This function returns the minute part of time recorded at an instant. The time recorded is referred to as timestamp which shows the time in standard number interpretation. The minutes returned by this function is as an integer value.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-mathematical-functions\/\">Let&#8217;s discuss Qlik Sense mathematical Functions<\/a><\/strong><\/p>\n<p><strong>The syntax of Qlik Sense minute function:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">minute(expression)<\/pre>\n<p><span style=\"font-weight: 400\">For example, <\/span><\/p>\n<p><span style=\"font-weight: 400\">The expression <\/span><span style=\"font-weight: 400\">minute(&#8217;11:14:36&#8242;)<\/span><span style=\"font-weight: 400\"> will return 14 as the minute in the time.<\/span><\/p>\n<p><span style=\"font-weight: 400\">And if you only mention one part of the timestamp, even then the minutes will be returned by the function, <\/span><span style=\"font-weight: 400\">minute(&#8216;0.5555&#8217;)<\/span><span style=\"font-weight: 400\"> returns 19 , because 0.5555 = 13:19:55 \u00a0which is the time stamp. <\/span><\/p>\n<h3><span style=\"font-weight: 400\">iii. hour() function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">The hour() function returns the hour part of the time, present in standard number interpretation. The value returned by this function is as an integer value. <\/span><\/p>\n<p><strong>The syntax of Qlik Sense hour function:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">hour(expression)<\/pre>\n<p><span style=\"font-weight: 400\">For example, <\/span><\/p>\n<p><span style=\"font-weight: 400\">In the time given in the example, <\/span><span style=\"font-weight: 400\">hour(&#8217;10:15:36&#8242;)<\/span><span style=\"font-weight: 400\"> the hour will be returned as 10.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Also, if you only mention one element of the time in the timestamp like, <\/span><span style=\"font-weight: 400\">hour(&#8217;15&#8217;)<\/span><span style=\"font-weight: 400\"> returns 10, because 15 is a minute element in the date 10:19:55. <\/span><\/p>\n<h3><span style=\"font-weight: 400\">iv. day() function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">The day() function returns an integer value for the day mentioned in the date recorded in the timestamp or a date entered manually.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/\">Know more about Qlik Sense mapping Functions<\/a><\/strong><\/p>\n<p><strong>The Syntax of Qlik Sense day function:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">day(expression)<\/pre>\n<p><span style=\"font-weight: 400\">For example, if the day function has a date, <\/span><span style=\"font-weight: 400\">day(22\/02\/1998)<\/span><span style=\"font-weight: 400\"> then the function will return 22 the integer value for day. Also, if you enter the number of days a particular date or day will on, this function will return the day of that date.<\/span><\/p>\n<p><span style=\"font-weight: 400\">For example<\/span><span style=\"font-weight: 400\">, day(&#8216;35648&#8217;)<\/span><span style=\"font-weight: 400\"> will return 6, because 35648 is the total days for the date 6\/08\/1997.<\/span><\/p>\n<h3><span style=\"font-weight: 400\">v. week() function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">This function returns the nth week or the number of week when it encounters a date. <\/span><\/p>\n<p><strong>The syntax of Qlik Sense week function:<\/strong><\/p>\n<p><b>week<\/b><b>(<\/b><span style=\"font-weight: 400\">timestamp[,first_week_day[,broken_weeks[,reference_day]]]<\/span><b>)<\/b><\/p>\n<p><span style=\"font-weight: 400\">Where, <\/span><i><span style=\"font-weight: 400\">timestamp<\/span><\/i><span style=\"font-weight: 400\"> is the date, <\/span><i><span style=\"font-weight: 400\">first_week_day<\/span><\/i><span style=\"font-weight: 400\"> is the number that you specify the day you want your week to start. Like, 0 for Monday, 1 for Tuesday, 2 for Wednesday, 3 for Thursday, 4 for Friday, 5 for Saturday and 6 for Sunday.<\/span><\/p>\n<p><i><span style=\"font-weight: 400\">broken_weeks<\/span><\/i><span style=\"font-weight: 400\"> sets the starting of counting the weeks from January of a year. There are two ways to set this, first is to use 0 for unbroken weeks i.e. week 1 will start on January 1, which is not usually a full week. The other option is to use 1 for broken weeks were the first week of January must at least have 4 days and so, it doesn\u2019t necessarily start from 1<\/span><span style=\"font-weight: 400\">st <\/span><span style=\"font-weight: 400\">of January. By default, Qlik Sense used unbroken weeks. <\/span><\/p>\n<p><i><span style=\"font-weight: 400\">reference_day<\/span><\/i><span style=\"font-weight: 400\"> decides the which day in the first week of January should be taken as the start of the 1<\/span><span style=\"font-weight: 400\">st<\/span><span style=\"font-weight: 400\"> week. You can use, 1 (= January 1), 2 (= January 2), 3 (= January 3), 4 (= January 4), 5 (= January 5), 6 (= January 6), 7 (= January 7) and so on. By default, this is set on 4. <\/span><\/p>\n<p><span style=\"font-weight: 400\">For example, <\/span><\/p>\n<p><span style=\"font-weight: 400\">In the expression <\/span><span style=\"font-weight: 400\">week(&#8216;2012-10-12&#8217;)<\/span><span style=\"font-weight: 400\"> the result would be 41. And if you use <\/span><span style=\"font-weight: 400\">week(&#8216;2012-10-12&#8217;, 0, 1)<\/span><span style=\"font-weight: 400\"> as the expression, where 0 is the first week day and 1 to specify broken weeks, returns 42 as the week number.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-counter-functions\/\">Have a look at Qlik Sense Counter Functions<\/a><\/strong><\/p>\n<h3><span style=\"font-weight: 400\">vi. month() function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">The month() function returns the month of a date both in text and number. As it returns both text (Jan to Dec) and numeric values (1 to 12) of month, it is said to be dual data format. <\/span><\/p>\n<p><strong>The syntax of Qlik Sense month Function:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">month(expression)<\/pre>\n<p><span style=\"font-weight: 400\">For example, <\/span><\/p>\n<p><span style=\"font-weight: 400\">The expression, <\/span><span style=\"font-weight: 400\">month(&#8216;2017-10-12&#8217;)<\/span><span style=\"font-weight: 400\"> returns Oct as the text result to the function and the numeric value would be 10. <\/span><\/p>\n<h3><span style=\"font-weight: 400\">vii. year() function <\/span><\/h3>\n<p><span style=\"font-weight: 400\">The year() function returns the year by evaluating a date encountered in \u00a0a script in standard numeric interpretation. <\/span><\/p>\n<p><strong>The Syntax of Qlik Sense Year Function:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">year(expression)<\/pre>\n<p><span style=\"font-weight: 400\">For example, <\/span><\/p>\n<p><span style=\"font-weight: 400\">The expression with a date, <\/span><span style=\"font-weight: 400\">year(&#8216;2017-10-12&#8217;)<\/span><span style=\"font-weight: 400\"> will return 2017 as it is the year. <\/span><\/p>\n<p><span style=\"font-weight: 400\">If the expression contains number of days instead of a date then,<\/span><\/p>\n<p><span style=\"font-weight: 400\">year(&#8216;35648&#8217;)<\/span><span style=\"font-weight: 400\"> where 35648 is the number of the day on which the date1997-08-06 will fall on, and so, it will evaluate the date from the number \u201835648\u2019 and return 1997.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-color-functions\/\">Let&#8217;s take a tour to Qlik Sense color function<\/a><\/strong><\/p>\n<h3><span style=\"font-weight: 400\">viii. weekyear() function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">This function returns the year corresponding to the number of week which is present in a date. The number of weeks in a year range from 1 to about 52 (may vary). <\/span><\/p>\n<p><strong>The syntax of Qlik Sense weekyear Function:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">weekyear(expression)<\/pre>\n<p><span style=\"font-weight: 400\">For example,<\/span><\/p>\n<p><span style=\"font-weight: 400\">The date given in the expression, <\/span><span style=\"font-weight: 400\">weekyear(&#8216;1996-12-30&#8217;)<\/span><span style=\"font-weight: 400\"> will return 1997, because week 1 of 1998 starts on 1996-12-30 and so will it be for the year 1997. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Or, <\/span><span style=\"font-weight: 400\">weekyear(&#8216;1997-01-02&#8217;)<\/span><span style=\"font-weight: 400\"> will return 1997 as the year corresponding to the first week of 1997.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Or, <\/span><span style=\"font-weight: 400\">weekyear(&#8216;1997-12-30&#8217;)<\/span><span style=\"font-weight: 400\"> which returns 1998 as week 1 of 1998 starts on 1997-12-29.<\/span><\/p>\n<h3><span style=\"font-weight: 400\">ix. weekday() function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">The weekday() function will return the weekday corresponding to a date. The value returned is dual i.e. it is both in text (Mon, Tue, Wed and so on till Sun) and number (from 0 to 6, where 0 is Monday and 6 is for Sunday). <\/span><\/p>\n<p><strong>The syntax of Qlik Sense weekday function:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">weekday(date [,first_week_day=0])<\/pre>\n<p><span style=\"font-weight: 400\">Where from the <\/span><i><span style=\"font-weight: 400\">first_week_day<\/span><\/i><span style=\"font-weight: 400\"> parameter, you can specify which day (0 for Monday to 6 for Sunday) you want to be as the first day of the week.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-pie-chart\/\">Do you know about Qlik Sense Pie chart<\/a><\/strong><\/p>\n<p><span style=\"font-weight: 400\">For example,<\/span><\/p>\n<p><span style=\"font-weight: 400\">The expression, <\/span><span style=\"font-weight: 400\">weekday(&#8216;1971-10-12&#8217;)<\/span><span style=\"font-weight: 400\"> will return \u2018Tue\u2019 and 1 because Monday would be 0 and so Tuesday is assigned to 1. <\/span><\/p>\n<p><span style=\"font-weight: 400\">And if you specify the number of day a week should start from in the place of first_week_day parameter,<\/span><\/p>\n<p><span style=\"font-weight: 400\">weekday(&#8216;1971-10-12&#8217; , 6)<\/span><\/p>\n<p><span style=\"font-weight: 400\">will return &#8216;Tue&#8217; and 2 because here as it is been specified the week should start from Sunday(6) and so according to this, Sunday is 0, Monday is 1 and Tuesday is 2.<\/span><\/p>\n<p>So, this was all in Qlik Sense integer functions of time. Hope you like our explanation.<\/p>\n<h2><span style=\"font-weight: 400\">3. Conclusion <\/span><\/h2>\n<p><span style=\"font-weight: 400\">Thus, the time integer functions are useful in giving important information related to time as integer values. They also return string or text values when required by some function, which makes using these functions very convenient.<\/span><\/p>\n<p>Still, if you have any query regarding Qlik Sense Integer Functions, ask in the comment tab.<\/p>\n<p><strong>See also &#8211;\u00a0\u00a0<\/strong><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-histogram\/\">Qlik Sense Histogram Visualization<\/a><\/strong><\/p>\n<p><strong><a href=\"https:\/\/www.qlik.com\/us\/products\/qlik-sense\">Reference for Qlik Sense\u00a0<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Objective In our last Qlik Sense Tutorial, we discussed Qlik Sense Time Zone Functions. Today we will see Qlik Sense Integer Functions of Time. The integer functions of time are used to evaluate&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":41822,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[3579,17644,17641,17643,8867,17640,17642,17645,17646,16333],"class_list":["post-41791","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-day-function","tag-hour-function","tag-integer-functions-of-time","tag-minute-fucntion","tag-month-function","tag-qlik-sense-integer-functions-of-time","tag-second-function","tag-week-function","tag-weekyear-function","tag-year-function"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Qlik Sense Integer Functions of Time With Syntax - DataFlair<\/title>\n<meta name=\"description\" content=\"Qlik Sense Integer Functions of Time,secobnd function,minute function,hour function,day function,week function,month function,year function,weekyear\" \/>\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-integer-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Integer Functions of Time With Syntax - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Qlik Sense Integer Functions of Time,secobnd function,minute function,hour function,day function,week function,month function,year function,weekyear\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-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:09:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Integer-Functions-of-Time-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=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qlik Sense Integer Functions of Time With Syntax - DataFlair","description":"Qlik Sense Integer Functions of Time,secobnd function,minute function,hour function,day function,week function,month function,year function,weekyear","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-integer-functions\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Integer Functions of Time With Syntax - DataFlair","og_description":"Qlik Sense Integer Functions of Time,secobnd function,minute function,hour function,day function,week function,month function,year function,weekyear","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-14T12:09:11+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Integer-Functions-of-Time-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":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Integer Functions of Time With Syntax","datePublished":"2018-11-14T12:09:11+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/"},"wordCount":1217,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Integer-Functions-of-Time-01.jpg","keywords":["DAY Function","hour Function","Integer Functions of Time","Minute Fucntion","MONTH Function","Qlik Sense Integer Functions of Time","Second Function","week function","weekyear function","YEAR Function"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/","name":"Qlik Sense Integer Functions of Time With Syntax - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Integer-Functions-of-Time-01.jpg","datePublished":"2018-11-14T12:09:11+00:00","description":"Qlik Sense Integer Functions of Time,secobnd function,minute function,hour function,day function,week function,month function,year function,weekyear","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Integer-Functions-of-Time-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Integer-Functions-of-Time-01.jpg","width":1200,"height":628,"caption":"Qlik Sense Integer Functions of Time With Syntax"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-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 Integer Functions of Time With Syntax"}]},{"@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\/41791","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=41791"}],"version-history":[{"count":4,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/41791\/revisions"}],"predecessor-version":[{"id":42063,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/41791\/revisions\/42063"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/41822"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=41791"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=41791"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=41791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}