

{"id":42843,"date":"2018-11-20T16:35:00","date_gmt":"2018-11-20T11:05:00","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=42843"},"modified":"2018-11-21T09:36:12","modified_gmt":"2018-11-21T04:06:12","slug":"qlik-sense-interpretation-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-functions\/","title":{"rendered":"Qlik Sense Interpretation Functions &#8211; Syntax &amp; Example"},"content":{"rendered":"<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 <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/\">Qlik Sense Day Numbering Functions<\/a><\/strong>. Today, we will see Qlik Sense Interpretation Functions. This lesson includes all the important functions used in Qlik Sense for interpreting input values in a certain format. We will discuss each interpretation function of Qlik Sense in this lesson in detail, with relevant examples.<\/span><\/p>\n<p>So, let&#8217;s start Qlik Sense Interpretation Functions tutorial.<\/p>\n<div id=\"attachment_42857\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Interpretation-Function-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-42857\" class=\"size-full wp-image-42857\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Interpretation-Function-01.jpg\" alt=\"Qlik Sense Interpretation Functions - Syntax &amp; Example\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Interpretation-Function-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Interpretation-Function-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Interpretation-Function-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Interpretation-Function-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Interpretation-Function-01-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Interpretation-Function-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-42857\" class=\"wp-caption-text\">Qlik Sense Interpretation Functions &#8211; Syntax &amp; Example<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/\">Have a look at Qlik Sense Field Functions\u00a0<\/a><\/strong><\/p>\n<h2><span style=\"font-weight: 400\">2. Qlik Sense Interpretation Functions<\/span><\/h2>\n<p><span style=\"font-weight: 400\">We use the Qlik Sense interpretation functions in the interpretation of data values that are input in Qlik Sense and formatting them in a specific format. Basically, we interpret the string values and convert into numeric values. This is just the opposite of what formatting functions do, as they convert the numeric values into the string values in a particular format. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Although, interpretation functions also return values in the dual data format i.e. both string and numeric interpretation for one input value. Both kinds of values have their significance. Given in the section below, we will discuss all the Qlik Sense Interpretation Functions in detail. <\/span><\/p>\n<h3><span style=\"font-weight: 400\">i. Date# function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">This function interprets the input text value for date and returns a numeric value corresponding to that text value. <\/span><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Date#(text[,format])<\/pre>\n<p><span style=\"font-weight: 400\">Where, <\/span><span style=\"font-weight: 400\">text<\/span><span style=\"font-weight: 400\"> is the string value which you want to be interpreted and converted as numeric value.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/\">Do you know about Qlik Sense Integer Functions<\/a><\/strong><\/p>\n<p><span style=\"font-weight: 400\">So, using the <\/span><span style=\"font-weight: 400\">format<\/span><span style=\"font-weight: 400\"> parameter, you can specify a format in which the text string must be interpreted. <\/span><\/p>\n<p><span style=\"font-weight: 400\"><strong>For example,<\/strong> in the code given below, we have loaded string values for dates and want to get their numeric interpretations in return. <\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Load *,\r\nNum(Date#(StringDate)) as Date;\r\nLOAD * INLINE [\r\nStringDate\r\n8\/7\/97\r\n8\/6\/1997\r\n];<\/pre>\n<p>Hence, this will return two fields, StringDate (string value) and Date (numeric value) where string and date values will return.<\/p>\n<table style=\"height: 93px\" width=\"320\">\n<tbody>\n<tr>\n<td><b>StringDate<\/b><\/td>\n<td><b>Date<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">8\/7\/97<\/span><\/td>\n<td><span style=\"font-weight: 400\">35649<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">8\/6\/1997<\/span><\/td>\n<td><span style=\"font-weight: 400\">35648<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><span style=\"font-weight: 400\">ii. Interval# function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">This function evaluates a text value as a time interval and returns a corresponding numeric value for it.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-time-zone-functions\/\">Let&#8217;s revise Qlik Sense Time Zone Function<\/a><\/strong><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Interval#(text[, format])<\/pre>\n<p><span style=\"font-weight: 400\">Where, <\/span><span style=\"font-weight: 400\">text<\/span><span style=\"font-weight: 400\"> is the string value which you want to be interpreted and converted as numeric value. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Using the <\/span><span style=\"font-weight: 400\">format<\/span><span style=\"font-weight: 400\"> parameter, you can specify a format in which the text string must be interpreted. If there is no specific format then, short date format (YY-MM-DD), time format (M\/D\/YY), and decimal separator (.) \u00a0in the operating system are considered automatically. <\/span><\/p>\n<p><span style=\"font-weight: 400\"><strong>For example,<\/strong> <\/span><\/p>\n<p><span style=\"font-weight: 400\">Interval#( T, &#8216;D hh:mm&#8217; ) <\/span><\/p>\n<p><span style=\"font-weight: 400\">where T=&#8217;1 09:00&#8242;<\/span><\/p>\n<p><span style=\"font-weight: 400\">Returns the numeric value 1.375 corresponding to the string \u20181 09:00\u2019. <\/span><\/p>\n<h3><span style=\"font-weight: 400\">iii. Money# function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">This function evaluates a string value for money format and returns a numeric value corresponding to the string value in that particular format. <\/span><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Money#(text[, format[, dec_sep [, thou_sep ] ] ])<\/pre>\n<p><span style=\"font-weight: 400\">Where, <\/span><span style=\"font-weight: 400\">text<\/span><span style=\"font-weight: 400\"> is the string value which you want to be interpreted and converted as numeric value.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-financial-functions\/\">Have a look at Qlik Sense Financial Functions<\/a><\/strong><\/p>\n<p><span style=\"font-weight: 400\">Using the <\/span><span style=\"font-weight: 400\">format<\/span><span style=\"font-weight: 400\"> parameter, you can specify a format in which the text string must be interpreted. If no format is specified, then the formatting options in the operating system like kr # ##0,00 and $ #,##0.00 are considered automatically. <\/span><\/p>\n<p><span style=\"font-weight: 400\">dec_sep<\/span><span style=\"font-weight: 400\"> sets the decimal separator which will separate the digits. If no such format is specified, then the system uses MoneyDecimalSep value stored in the system. <\/span><\/p>\n<p><span style=\"font-weight: 400\">thou_sep <\/span><span style=\"font-weight: 400\">sets the separator used to separate thousand numbers. If no such separator is mentioned, then the system used MoneyThousandSep value. <\/span><\/p>\n<p><strong>For example, <\/strong><\/p>\n<p><span style=\"font-weight: 400\">Money#( M, &#8216; $#&#8217;, &#8216;.&#8217;, &#8216;,&#8217; ) <\/span><\/p>\n<p><span style=\"font-weight: 400\">where M= $35,648.50<\/span><\/p>\n<p><span style=\"font-weight: 400\">Returns, \u2018$35,648.50\u2019 as the string value and 35648.50 as the numeric value. <\/span><\/p>\n<h3><span style=\"font-weight: 400\">iv. Num# function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">This function evaluates a string having numbers and evaluates them to return corresponding numeric values.<\/span><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Num#(text[, format[, dec_sep [, thou_sep ] ] ])<\/pre>\n<p><span style=\"font-weight: 400\">Where, <\/span><span style=\"font-weight: 400\">text<\/span><span style=\"font-weight: 400\"> is the string value which you want to be interpreted and converted as numeric value. <\/span><\/p>\n<p><span style=\"font-weight: 400\">So, using the <\/span><span style=\"font-weight: 400\">format<\/span><span style=\"font-weight: 400\"> parameter, you can specify a format in which the text string must be interpreted. If no format is specified, then the formatting options in the operating system like # ##0 and #,##0 are considered automatically.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/\">Let&#8217;s take a tour to Qlik Sense Table Functions<\/a><\/strong><\/p>\n<p><span style=\"font-weight: 400\">dec_sep<\/span><span style=\"font-weight: 400\"> sets the decimal separator which will separate the digits. If no such format is specified, then the system uses DecimalSep value stored in the system. <\/span><\/p>\n<p><span style=\"font-weight: 400\">thou_sep <\/span><span style=\"font-weight: 400\">sets the separator used to separate thousand numbers. If no such separator is mentioned, then the system used ThousandSep value. <\/span><\/p>\n<p><span style=\"font-weight: 400\">For instance, the piece of code given below returns, <\/span><\/p>\n<p><span style=\"font-weight: 400\">Num#(N, &#8216;#.#&#8217;, &#8216;.&#8217; , &#8216;,&#8217;) <\/span><\/p>\n<p><span style=\"font-weight: 400\">where N=35,648.50<\/span><\/p>\n<p><span style=\"font-weight: 400\">Returns, 35,648.50 as a string value and 35648.50 as the numeric value. Please note that the formatting applied is applicable only on the string part and not on the numeric part of the outcome. <\/span><\/p>\n<h3><span style=\"font-weight: 400\">v. Text# function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">This function solely evaluates a string value and does not convert it into a numeric value. It keeps the values as text only. <\/span><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Text(expr)<\/pre>\n<p><span style=\"font-weight: 400\">For instance, <\/span><\/p>\n<p><span style=\"font-weight: 400\">Text(Address)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Where Address= FlatNo.152, Crystal Township, Delhi<\/span><\/p>\n<p><span style=\"font-weight: 400\">Will only return a text value i.e. \u2018FlatNo.152, Crystal Township, Delhi\u2019. No numeric interpretation corresponding to this will be done.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/\">You must learn Qlik Sense Logical Functions\u00a0<\/a><\/strong><\/p>\n<p><span style=\"font-weight: 400\">Or, <\/span><\/p>\n<p><span style=\"font-weight: 400\">Text( pi( ) )<\/span><\/p>\n<p><span style=\"font-weight: 400\">Will return \u20183.1415926535898\u2019 as string value. <\/span><\/p>\n<h3><span style=\"font-weight: 400\">vi. Time# function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">This function evaluates a text or string value for time format and returns a numeric value corresponding to it.<\/span><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">time#(text[, format])<\/pre>\n<p><span style=\"font-weight: 400\">Where, <\/span><span style=\"font-weight: 400\">text<\/span><span style=\"font-weight: 400\"> is the string value which you want to be interpreted and converted as numeric value. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Using the <\/span><span style=\"font-weight: 400\">format<\/span><span style=\"font-weight: 400\"> parameter, you can specify a format in which the text string must be interpreted. If no format is specified, then formats stored by default such as hh:mm:ss and in the operating system are considered automatically. <\/span><\/p>\n<p><span style=\"font-weight: 400\">For instance, <\/span><\/p>\n<p><span style=\"font-weight: 400\">time#( T ) <\/span><\/p>\n<p><span style=\"font-weight: 400\">where T=09:00:00<\/span><\/p>\n<p><span style=\"font-weight: 400\">Returns a string value as \u201809:00:00\u2019 and a numeric value corresponding to it, which is 0.375.<\/span><\/p>\n<h3><span style=\"font-weight: 400\">vii. Timestamp# function<\/span><\/h3>\n<p><span style=\"font-weight: 400\">This function evaluates a string in date and time format (making a timestamp) and returns a numeric value corresponding to it.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/trigonometric-and-hyperbolic-functions\/\">Do you know about Qlik Sense Hyperbolic Functions<\/a><\/strong><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">timestamp#(text[, format])<\/pre>\n<p><span style=\"font-weight: 400\">Where, <\/span><span style=\"font-weight: 400\">text<\/span><span style=\"font-weight: 400\"> is the string value which you want to be interpreted and converted as numeric value. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Using the <\/span><span style=\"font-weight: 400\">format<\/span><span style=\"font-weight: 400\"> parameter, you can specify a format in which the text string must be interpreted. If we specify no format, then it automatically considers default formats such as hh:mm:ss and short date format (YY-MM-DD), time format (M\/D\/YY), and decimal separator (.).<\/span><\/p>\n<p><span style=\"font-weight: 400\"><strong>For example,<\/strong> <\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Load *,\r\nTimestamp(Timestamp#(String)) as TS;\r\nLOAD * INLINE [\r\nStringValue\r\n2015-09-15T12:13:14\r\n1952-10-16T13:14:00+0200\r\n1109-03-01T14:15\r\n];<\/pre>\n<p><span style=\"font-weight: 400\">Returns both string and numeric values for each data value entered inline. <\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>StringValue<\/b><\/td>\n<td><b>TS<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">2015-09-15T12:13:14<\/span><\/td>\n<td><span style=\"font-weight: 400\">9\/15\/2015 12:13:14 PM<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">1952-10-16T13:14:00+0200<\/span><\/td>\n<td><span style=\"font-weight: 400\">10\/16\/1952 11:14:00 AM<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">1109-03-01T14:15<\/span><\/td>\n<td><span style=\"font-weight: 400\">3\/1\/1109 2:15:00 PM<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>So, this was all in Qlik Sense Interpretation Functions. 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, we have learned all the important interpretation functions used in Qlik Sense data handling. If you mention no form of interpretation for a data value in an expression in a data load script, then it takes up as a value having mixed data values like numbers, dates, times, time stamps and strings, using the default settings for formats like, number format, date format, and time format, defined by script variables the operating system.<\/span><\/p>\n<p><strong>See also-\u00a0<\/strong><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-mathematical-functions\/\">Qlik Sense Mathematical Functions<\/a><\/strong><\/p>\n<p><strong><a href=\"https:\/\/help.qlik.com\/en-US\/sense\/November2018\/Subsystems\/Hub\/Content\/Sense_Hub\/Scripting\/InterpretationFunctions\/interpretation-functions.htm\">Reference for Qlik Sense<\/a><\/strong><span hidden class=\"__iawmlf-post-loop-links\" data-iawmlf-links=\"[{&quot;id&quot;:1726,&quot;href&quot;:&quot;https:\\\/\\\/help.qlik.com\\\/en-US\\\/sense\\\/November2018\\\/Subsystems\\\/Hub\\\/Content\\\/Sense_Hub\\\/Scripting\\\/InterpretationFunctions\\\/interpretation-functions.htm&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251209210139\\\/https:\\\/\\\/help.qlik.com\\\/en-US\\\/sense\\\/November2018\\\/Subsystems\\\/Hub\\\/Content\\\/Sense_Hub\\\/Scripting\\\/InterpretationFunctions\\\/interpretation-functions.htm&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-14 03:34:11&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-19 22:40:25&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-24 11:23:49&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2025-12-30 04:36:52&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-02 06:33:43&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-13 10:30:43&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-19 18:57:22&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-24 15:36:46&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-03 09:16:29&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-09 03:40:32&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-30 13:52:00&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-22 13:43:18&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-27 21:09:01&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-07-03 02:04:59&quot;,&quot;http_code&quot;:200}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-07-03 02:04:59&quot;,&quot;http_code&quot;:200},&quot;process&quot;:&quot;done&quot;}]\"><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Objective In our last Qlik Sense Tutorial, we discussed Qlik Sense Day Numbering Functions. Today, we will see Qlik Sense Interpretation Functions. This lesson includes all the important functions used in Qlik Sense&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":42857,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[17666,17665,17667,17668,17669,17664,17670,17671,17672],"class_list":["post-42843","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-date-function","tag-interpretation-functions-of-qlik-sense","tag-interval-function","tag-money-function","tag-num-function","tag-qlik-sense-interpretation-functions","tag-text-function","tag-time-function","tag-timestamp-function"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Qlik Sense Interpretation Functions - Syntax &amp; Example - DataFlair<\/title>\n<meta name=\"description\" content=\"Qlik Sense Interpretation Functions,Date Functions, Interval Functions,Money Functions,Num Functions, Text Functions, Time Functions,Timestamp Functions\" \/>\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-interpretation-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Interpretation Functions - Syntax &amp; Example - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Qlik Sense Interpretation Functions,Date Functions, Interval Functions,Money Functions,Num Functions, Text Functions, Time Functions,Timestamp Functions\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-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-20T11:05:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-21T04:06:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Interpretation-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=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qlik Sense Interpretation Functions - Syntax &amp; Example - DataFlair","description":"Qlik Sense Interpretation Functions,Date Functions, Interval Functions,Money Functions,Num Functions, Text Functions, Time Functions,Timestamp Functions","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-interpretation-functions\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Interpretation Functions - Syntax &amp; Example - DataFlair","og_description":"Qlik Sense Interpretation Functions,Date Functions, Interval Functions,Money Functions,Num Functions, Text Functions, Time Functions,Timestamp Functions","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-functions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-20T11:05:00+00:00","article_modified_time":"2018-11-21T04:06:12+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Interpretation-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":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-functions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-functions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Interpretation Functions &#8211; Syntax &amp; Example","datePublished":"2018-11-20T11:05:00+00:00","dateModified":"2018-11-21T04:06:12+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-functions\/"},"wordCount":1151,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Interpretation-Function-01.jpg","keywords":["Date Function","Interpretation Functions of Qlik sense","Interval Function","Money Function","Num Function","Qlik Sense Interpretation Functions","Text Function","Time Function","Timestamp Function"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-functions\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-functions\/","name":"Qlik Sense Interpretation Functions - Syntax &amp; Example - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-functions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Interpretation-Function-01.jpg","datePublished":"2018-11-20T11:05:00+00:00","dateModified":"2018-11-21T04:06:12+00:00","description":"Qlik Sense Interpretation Functions,Date Functions, Interval Functions,Money Functions,Num Functions, Text Functions, Time Functions,Timestamp Functions","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-functions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Interpretation-Function-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Interpretation-Function-01.jpg","width":1200,"height":628,"caption":"Qlik Sense Interpretation Functions - Syntax &amp; Example"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-interpretation-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 Interpretation Functions &#8211; Syntax &amp; 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\/42843","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=42843"}],"version-history":[{"count":4,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/42843\/revisions"}],"predecessor-version":[{"id":43008,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/42843\/revisions\/43008"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/42857"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=42843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=42843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=42843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}