{"id":42577,"date":"2018-11-17T16:46:09","date_gmt":"2018-11-17T11:16:09","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=42577"},"modified":"2018-11-19T16:58:04","modified_gmt":"2018-11-19T11:28:04","slug":"qlik-sense-day-numbering-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/","title":{"rendered":"Qlik Sense Day Numbering Functions With Example"},"content":{"rendered":"

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

In our last Qlik Sense tutorial, we discussed Qlik Sense Date and Time Functions<\/a><\/strong>. Today, we will see Qlik Sense Day Numbering Functions. These functions return dates and numbers for specific cases of time and date mentioned in the functions. So, you can get these functions to calculate numbers like age, net work days, first and last work dates, day numbers of years and quarters from given information like timestamp (date and time), date of birth etc. In this lesson, we will learn about the day numbering functions in Qlik Sense in detail.<\/span><\/p>\n

So, let’s start Qlik Sense Day Numbering Functions Tutorial.<\/p>\n

\"Qlik<\/a>

Qlik Sense Day Numbering Functions With Example<\/p><\/div>\n

2. Qlik Sense Day Numbering Functions<\/h2>\n

Following are some Qlik Sense Day Numbering Functions –<\/p>\n

You must read Qlik Sense Time Zone Function<\/a><\/strong><\/p>\n

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

The age function returns the age of a person in years which is evaluated by the information given in the timestamp (which is the current date) and the date of birth of the person. This function returns a numeric value. <\/span><\/p>\n

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

age(timestamp, date_of_birth)<\/pre>\n
For example, if you are using the DD\/MM\/YYYY date format then,<\/span><\/p>\n
age(’25\/01\/2018′,’25\/12\/2010\u2019)<\/span> will return 6 as the person would complete 6 years and would have 7<\/span>th<\/span> year as running on the 25<\/span>th <\/span>of January,2018 which is the timestamp value. <\/span><\/p>\n
Enter the script given below in the script editor of your Qlik Sense application and see what results you get.<\/span><\/p>\n
Employees:\r\nLOAD * INLINE [\r\nMember|DateOfBirth\r\nJohn|28\/03\/1989\r\nKacey|10\/12\/1990\r\nSteven|5\/2\/1992\r\nSamuel|31\/3\/1993\r\nChris|19\/5\/1994\r\nMike|15\/9\/1994\r\nKendal|11\/12\/1994\r\nJenny|2\/3\/1995\r\nKatie|14\/5\/1996\r\nMathew|13\/6\/1996\r\nPeter|7\/7\/1998\r\nEmma|4\/8\/2000\r\n] (delimiter is |);\r\nAgeTable:\r\nLoad *,\r\nage('20\/08\/2015', DateOfBirth) As Age\r\nResident Employees;\r\nDrop table Employees;<\/pre>\n
This will result in three new fields, Member, DateOfBirth and Age which if you see in a table will look like this were all the ages are generated by the age() function which we used in the script above.<\/span><\/p>\n
Do you know about Qlik Sense In Functions<\/a><\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Member<\/b><\/td>\nDateOfBirth<\/b><\/td>\nAge<\/b><\/td>\n<\/tr>\n
John<\/span><\/td>\n28\/03\/1989<\/span><\/td>\n26<\/span><\/td>\n<\/tr>\n
Kacey<\/span><\/td>\n10\/12\/1990<\/span><\/td>\n24<\/span><\/td>\n<\/tr>\n
Steven<\/span><\/td>\n5\/2\/1992<\/span><\/td>\n23<\/span><\/td>\n<\/tr>\n
Samuel<\/span><\/td>\n31\/3\/1993<\/span><\/td>\n22<\/span><\/td>\n<\/tr>\n
Chris<\/span><\/td>\n19\/5\/1994<\/span><\/td>\n21<\/span><\/td>\n<\/tr>\n
Mike<\/span><\/td>\n15\/9\/1994<\/span><\/td>\n20<\/span><\/td>\n<\/tr>\n
Kendal<\/span><\/td>\n11\/12\/1994<\/span><\/td>\n20<\/span><\/td>\n<\/tr>\n
Jenny<\/span><\/td>\n2\/3\/1995<\/span><\/td>\n20<\/span><\/td>\n<\/tr>\n
Katie<\/span><\/td>\n14\/5\/1996<\/span><\/td>\n19<\/span><\/td>\n<\/tr>\n
Mathew<\/span><\/td>\n13\/6\/1996<\/span><\/td>\n19<\/span><\/td>\n<\/tr>\n
Peter<\/span><\/td>\n7\/7\/1998<\/span><\/td>\n17<\/span><\/td>\n<\/tr>\n
Emma<\/span><\/td>\n4\/8\/2000<\/span><\/td>\n15<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
ii. networkdays() function <\/span><\/h3>\n
The networkdays() function returns the total working days i.e. Monday to Friday excluding Saturday. Sunday and any holidays are specified in the function expression.<\/span><\/p>\n
Let’s discuss Qlik Sense Financial Functions<\/a><\/strong><\/p>\n
The syntax of Qlik Sense networkdays function<\/strong>:<\/strong> <\/span><\/p>\n
networkdays(start_date, end_date [, holiday])<\/pre>\n
Where start and end date specify the time period for which you want to calculate the net working days. If you want to specify any holidays, you can do so by specifying the holiday dates in the expression like ’25\/12\/2013′, ’26\/12\/2013′, ’31\/12\/2013′, ’01\/01\/2014′ which are separated by commas. <\/span><\/p>\n
For example, <\/span><\/p>\n
networkdays ('19\/12\/2013', '07\/01\/2014', '25\/12\/2013', '26\/12\/2013')<\/pre>\n
This returns 12 as the net working days. It is so calculated that the holidays 25\/12\/2013 to 26\/12\/2013 are taken into account.<\/span><\/p>\n
iii. firstworkdate() function<\/span><\/h3>\n
This function returns the first work date (i.e. start date) given the end date of work and net working dates are mentioned in the function as parameters. It also considers any holidays while evaluating the expression, if mentioned. It returns the values as integer. <\/span><\/p>\n
The syntax for firstworkdate function:<\/strong><\/p>\n
firstworkdate(end_date, no_of_workdays {, holiday})<\/pre>\n
For example, <\/span><\/p>\n
firstworkdate (’29\/12\/2017′, 10)<\/strong> will return 16\/12\/2017 as the first work date. <\/span><\/p>\n
If you specify the holidays as well, it will be like,<\/span><\/p>\n
firstworkdate (’29\/12\/2017′, 9, ’25\/12\/2017′, ’26\/12\/2017′) <\/strong>will return 15\/12\/2017 as the first work date where the dates 25\/12\/2017 and 26\/12\/2017 are holidays. <\/span><\/p>\n
iv. lastworkdate() function <\/span><\/h3>\n
Contrary to the firstworkdate() function, the lastworkdate() returns the last date of work i.e. the end date of a time period based on the net working days. This function returns values in dual data type.<\/span><\/p>\n
Let’s take a tour to Qlik Sense Logical Functions<\/a><\/strong><\/p>\n
The syntax\u00a0 of Qlik Sense lastworkdate function:<\/strong><\/p>\n
lastworkdate(start_date, no_of_workdays {, holiday})<\/pre>\n
For example, <\/span><\/p>\n
lastworkdate (’19\/12\/2017′, 9)<\/span> expression will return 31\/12\/2017 as the last work date. Where, the date 19\/12\/2017 is the start date and 9 is the number of work days after which we want to know the end date or last work date. You also specify holidays in the expression separating the dates \u00a0by comma if more than one. <\/span><\/p>\n
v. daynumberofyear() function <\/span><\/h3>\n
This function returns the day number from 366 days in a year based on the current date, timestamp or a date that is specified in the function. You can also make the function calculate the day nth day from a particular month\u2019s start (i.e. 1<\/span>st<\/span> of that month) by specifying that month in numbers in the function. This function returns the value with integer as the data type. <\/span><\/p>\n
The syntax of Qlik Sense day numbering functions:<\/strong><\/p>\n
DayNumberOfYear(timestamp[,start_month])<\/pre>\n
For example, <\/span><\/p>\n
DayNumberOfYear(’12\/09\/2017′)<\/strong> returns 256 which the number of day this date falls on from the 1<\/span>st<\/span> of January 2017. <\/span><\/p>\n
If you specify a month, then the result will be, <\/span><\/p>\n
DayNumberOfYear(’12\/09\/2017′,3)<\/strong>\u00a0<\/span>returns 196 as the number of the day encountered starting from 1<\/span>st<\/span> of March. <\/span><\/p>\n
vi. daynumberofquarter() function <\/span><\/h3>\n
As the 12 months in a year can be divided into three quarters, this function returns the number of the day a particular date is falling on in the quarter in which it resides. <\/span><\/p>\n
The syntax of Qlik Sense Day Numbering Functions:<\/strong><\/p>\n
DayNumberOfQuarter(timestamp[,start_month])<\/pre>\n
Where timestamp is the date you want to know the day number in the quarter of and start_month is the number of month you want to set as the starting month for this evaluation. This function always returns an integer value.<\/span><\/p>\n
You must read Qlik Sense Mathematical Functions<\/a><\/strong><\/p>\n
For example,<\/strong> <\/span><\/p>\n
DayNumberOfQuarter('12\/09\/2017')<\/pre>\n
This will return 74 as the day number of the current quarter.<\/span><\/p>\n
DayNumberOfQuarter('12\/09\/2014',3)<\/pre>\n
This returns 12 as the day number of the current quarter. The quarter will start from the 3<\/span>rd<\/span> month that is, the month of March.<\/span><\/p>\n
So, this was all in Qlik Sense Day Numbering Functions. Hope you like our explanation.<\/p>\n
3. Conclusion <\/span><\/h2>\n
Hence, we discussed all the Qlik Sense Day Numbering Functions. Thus, these functions are very useful in making calculations related to days and dates and save a lot of user\u2019s time.<\/span><\/p>\n
Share your feedback of reading Qlik Sense Day Numbering Functions with us.<\/p>\n
See also-\u00a0<\/strong><\/p>\n
Qlik Sense Integer Functions<\/a><\/strong><\/p>\n
Reference for Qlik Sense\u00a0<\/a><\/strong>
1. Objective In our last Qlik Sense tutorial, we discussed Qlik Sense Date and Time Functions. Today, we will see Qlik Sense Day Numbering Functions. These functions return dates and numbers for specific cases...<\/p>\n","protected":false},"author":6,"featured_media":42645,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[17652,17659,17657,17656,17654,17655,17653,17658],"class_list":["post-42577","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-age-function","tag-day-numbering-functions-in-qlik-sense","tag-daynumberofquarter-function","tag-daynumberofyear-function","tag-firstworkdate-function","tag-lastworkdate-function","tag-networkdays-function","tag-qlik-sense-day-numbering-functions"],"yoast_head":"\nQlik Sense Day Numbering Functions With Example - DataFlair<\/title>\n<meta name=\"description\" content=\"Qlik Sense Day Numbering Functions,Age function, networkdays function,firstworkdate,lastworkdate,daynumberofquarter,daynumberofyear\" \/>\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-day-numbering-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Day Numbering Functions With Example - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Qlik Sense Day Numbering Functions,Age function, networkdays function,firstworkdate,lastworkdate,daynumberofquarter,daynumberofyear\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-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-17T11:16:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-19T11:28:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Day-Numbering-Functions-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=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qlik Sense Day Numbering Functions With Example - DataFlair","description":"Qlik Sense Day Numbering Functions,Age function, networkdays function,firstworkdate,lastworkdate,daynumberofquarter,daynumberofyear","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-day-numbering-functions\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Day Numbering Functions With Example - DataFlair","og_description":"Qlik Sense Day Numbering Functions,Age function, networkdays function,firstworkdate,lastworkdate,daynumberofquarter,daynumberofyear","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-17T11:16:09+00:00","article_modified_time":"2018-11-19T11:28:04+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Day-Numbering-Functions-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":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Day Numbering Functions With Example","datePublished":"2018-11-17T11:16:09+00:00","dateModified":"2018-11-19T11:28:04+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/"},"wordCount":945,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Day-Numbering-Functions-01.jpg","keywords":["Age Function","Day Numbering Functions in Qlik Sense","daynumberofquarter function","daynumberofyear function","firstworkdate function","lastworkdate function","networkdays function","Qlik Sense Day Numbering Functions'"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/","name":"Qlik Sense Day Numbering Functions With Example - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Day-Numbering-Functions-01.jpg","datePublished":"2018-11-17T11:16:09+00:00","dateModified":"2018-11-19T11:28:04+00:00","description":"Qlik Sense Day Numbering Functions,Age function, networkdays function,firstworkdate,lastworkdate,daynumberofquarter,daynumberofyear","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Day-Numbering-Functions-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Day-Numbering-Functions-01.jpg","width":1200,"height":628,"caption":"Qlik Sense Day Numbering Functions With Example"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-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 Day Numbering Functions 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\/42577","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=42577"}],"version-history":[{"count":2,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/42577\/revisions"}],"predecessor-version":[{"id":42646,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/42577\/revisions\/42646"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/42645"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=42577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=42577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=42577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}