

{"id":42869,"date":"2018-11-21T11:46:25","date_gmt":"2018-11-21T06:16:25","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=42869"},"modified":"2018-11-20T17:56:28","modified_gmt":"2018-11-20T12:26:28","slug":"qlik-sense-formatting-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-functions\/","title":{"rendered":"Qlik Sense Formatting Functions &#8211; Syntax and 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-interpretation-functions\/\">Qlik Sense interpretation Functions<\/a><\/strong>. Today, we will see Qlik Sense Formatting Functions. We use the formatting functions in Qlik Sense to format numeric values in certain formats like as time, date, money, interval, number etc. Such functions return values in dual format i.e. for every value there is a string and a numeric interpretation. Essentially, the Qlik Sense Formatting Functions convert numeric values (taken as input) into a string representation which represents the input numeric value.<\/span><\/p>\n<p>So, let&#8217;s start Qlik Sense Formatting Functions Tutorial.<\/p>\n<div id=\"attachment_42995\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Formatting-Functions-01-2.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-42995\" class=\"size-full wp-image-42995\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Formatting-Functions-01-2.jpg\" alt=\"Qlik Sense Formatting Functions\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Formatting-Functions-01-2.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Formatting-Functions-01-2-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Formatting-Functions-01-2-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Formatting-Functions-01-2-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Formatting-Functions-01-2-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Formatting-Functions-01-2-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-42995\" class=\"wp-caption-text\">Qlik Sense Formatting Functions<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/\">Have a look at Qlik Sense Table Functions<\/a><\/strong><\/p>\n<h2>2. Qlik Sense Formatting Functions<\/h2>\n<h3><span style=\"font-weight: 400\">i. ApplyCodepage() function in Qlik Sense<\/span><\/h3>\n<p><span style=\"font-weight: 400\">We use the applycodepage() function to apply the format i.e. the character set of a codepage onto a chart expression or another page. We commonly use this function when we want to copy a certain character from one section of code to another. In script expressions, we mostly use this function. <\/span><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">ApplyCodepage(text, codepage)<\/pre>\n<p><span style=\"font-weight: 400\">Where from the <\/span><span style=\"font-weight: 400\">text<\/span><span style=\"font-weight: 400\"> parameter, you can mention the field or text upon which you want to apply the codepage.<\/span><\/p>\n<p><em><span style=\"font-weight: 400\">codepage<\/span><span style=\"font-weight: 400\"> is the character set that is to be applied on the field or text.<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">For instance, we have a piece of code, where we want to apply character sets of respective languages to three rows. We will do it for each row using the applycodepage function.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/\">Do you know about Qlik Sense Null Functions<\/a><\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">LOAD\r\nApplyCodepage(ROWA,1253) as\r\nGreekProduct,\r\nApplyCodepage (ROWB, 1255) as\r\nHebrewProduct,\r\nApplyCodepage (ROWC, 65001) as\r\nEnglishProduct;\r\nSQL SELECT ROWA, ROWB, ROWC From\r\nProducts;<\/pre>\n<p><span style=\"font-weight: 400\">Thus, this will apply Windows Greek character set, for which the corresponding number is 1253 to the field ROWA. Similarly, 1255 and 65001 are the standard UTF-8 character sets for Hebrew and English\/Latin respectively which we will apply on ROWB and ROWC fields respectively. These three fields are loaded from <strong><a href=\"https:\/\/data-flair.training\/blogs\/sql-tutorial\/\">SQL<\/a><\/strong> and are not in the required character sets. So, we use this function to apply the standard Windows character sets. <\/span><\/p>\n<h3><span style=\"font-weight: 400\">ii. Date() function in Qlik Sense\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400\">The date() function specifies a date format for a value or expression in the data load script. Like all the formatting functions, this function also returns value in dual format i.e. both text and numeric interpretations.<\/span><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Date(number[, format])<\/pre>\n<p><span style=\"font-weight: 400\">Where, the number is the value for which you want to set the date format. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Using the format parameter, you can specify the format of the date or else the default formats can assume as saved in the system. There are two types of formats that are in the system by default, they are, YY-MM-DD and M\/D\/YY.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/\">You must read Qlik Sense Logical Functions<\/a><\/strong><\/p>\n<p><span style=\"font-weight: 400\">Example of using this function in a code,<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Date( Startday )<\/pre>\n<p><span style=\"font-weight: 400\">where Startday=35648<\/span><\/p>\n<p><span style=\"font-weight: 400\">This expression will return two values, numeric and text for both the default data types. For the YY-MM-DD setting, the date (string) representation would be 97-08-06 and numeric interpretation would be 35648. Similarly, for the M\/D\/YY format, the string representation is 8\/6\/97 and numeric representation is 35648.<\/span><\/p>\n<p><span style=\"font-weight: 400\">You can also specify the date format as given in the code below. <\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Date(Joining, 'DD\/MM\/YYYY')<\/pre>\n<p><span style=\"font-weight: 400\">where Joining=35648<\/span><\/p>\n<p><span style=\"font-weight: 400\">Thus, the string representation corresponding to this number is 06\/08\/1997 and the numeric representation is 35648. <\/span><\/p>\n<h3><span style=\"font-weight: 400\">iii. Dual() function in Qlik Sense<\/span><\/h3>\n<p><span style=\"font-weight: 400\">We use the dual() function, as the name suggests to create both textual (string) and numeric representation of a value. Like as we saw in the example above, we had a textual representation \u201806\/08\/1997\u2019 for the numeric value 35648 for a single date. Dual values are useful to create because in their case, the textual value is used for display or representation purposes and the numeric counterpart of that value is used for storage and calculation purposes.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/\">Have a look at Qlik Sense Field Functions<\/a><\/strong><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Dual(text, number)<\/pre>\n<p><span style=\"font-weight: 400\">Where, the text is the textual value that you want to have a numeric part for and the number parameter is the numeric value which you want to use with the string value in an argument.<\/span><\/p>\n<p><span style=\"font-weight: 400\">For instance, in the code given below, we have loaded a field named DayOfWeek which contains weekdays both as string representations and have corresponding numbers to the strings. The numerical part is used in sorting these weekdays numerically and if the weekdays are referred by numbers in another function then these numbers (0 to 6) can be used by the system\u2019s logic to understand which weekday is being mentioned. <\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Load dual ( DayName,DayNumber ) as DayOfWeek inline\r\n[ DayName,DayNumber,\r\nMonday,0\r\nTuesday,1\r\nWednesday,2\r\nThursday,3\r\nFriday,4\r\nSaturday,5\r\nSunday,6 ];<\/pre>\n<h3>iv. Interval() function in Qlik Sense<\/h3>\n<p><span style=\"font-weight: 400\">The interval() function defines an interval format for date and time intervals which are generally used in chart expressions and data load scripts. Intervals can be formatted in many ways like as time, as a day, as time and day both which has both, the elements of a date and that of time.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/\">Let&#8217;s take a tour to Qlik Sense Numbering Functions<\/a><\/strong><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Interval(number[, format])<\/pre>\n<p><span style=\"font-weight: 400\">Where <\/span><span style=\"font-weight: 400\">number<\/span><span style=\"font-weight: 400\"> is the numeric value which you want to get formatted as interval.<\/span><\/p>\n<p><span style=\"font-weight: 400\">By mentioning the <\/span><span style=\"font-weight: 400\">format<\/span><span style=\"font-weight: 400\">, you set the type of formatting which you want to apply on the number. If no type of formatting mentioned, then the default formats are applied like, YY-MM-DD for date and hh:mm:ss for time and a number decimal separator. \u00a0<\/span><\/p>\n<p><strong>For example,<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Interval( Day )<\/pre>\n<p><span style=\"font-weight: 400\">where Day=0.375 <\/span><\/p>\n<p><span style=\"font-weight: 400\">Returns, a string value \u201909:00:00\u2019 and a corresponding number 0.375 for this value. Thus, this function return values in dual data formats. <\/span><\/p>\n<h3><span style=\"font-weight: 400\">v. Money() function in Qlik Sense<\/span><\/h3>\n<p><span style=\"font-weight: 400\">The money() function is used to format values as representation of money. The formatting sets are usually taken from the available system variables in the data load script or in the operating system. If you wish to apply any other money format on the values, you need to specify them in the expression with valid decimal and thousands separator.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-integer-functions\/\">You must read Qlik Sense integer Functions<\/a><\/strong><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Money(number[, format[, dec_sep[, thou_sep]]])<\/pre>\n<p><span style=\"font-weight: 400\">Where, <\/span><span style=\"font-weight: 400\">number<\/span><span style=\"font-weight: 400\"> is the value which needs to be formatted as money.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Format<\/span><span style=\"font-weight: 400\"> is the specific format which is system defined or mentioned by the user. If you do not specify a format in this function, then the formats saved in the system as defaults are taken up. There are two types of money formats which are available in the system, first is <\/span><span style=\"font-weight: 400\">kr ##0,00, MoneyThousandSep&#8217; &#8216;<\/span><span style=\"font-weight: 400\"> and the second is <\/span><span style=\"font-weight: 400\">$ #,##0.00, MoneyThousandSep&#8217;,&#8217;<\/span><span style=\"font-weight: 400\">. <\/span><\/p>\n<p><span style=\"font-weight: 400\">dec_sep<\/span><span style=\"font-weight: 400\"> is the string which specifies the decimal number separator. <\/span><\/p>\n<p><span style=\"font-weight: 400\">thou_sep<\/span><span style=\"font-weight: 400\"> is the string which specifies the thousands number separator. <\/span><\/p>\n<p><span style=\"font-weight: 400\"><strong>For example<\/strong>, suppose we mention the money format for values in the variable, amount. <\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Money( Amount, '#,##0 $', '.' , ',' )<\/pre>\n<p><span style=\"font-weight: 400\">where Amount=3564800<\/span><\/p>\n<p><span style=\"font-weight: 400\">It will return a string representation as 3,564,800 $ and a number which is 3564800. \u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400\">vi. Num() function in Qlik Sense\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400\">This function formats values as numbers. In this function, you can specify the format for a number or use the pre-defined formatting set provided by the system. This function also returns a dual format value.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-scatter-plot\/\">Do you know about Qlik Sense Scatter Plot<\/a><\/strong><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Num(number[, format[, dec_sep [, thou_sep]]])<\/pre>\n<p><span style=\"font-weight: 400\">Where, <\/span><span style=\"font-weight: 400\">number<\/span><span style=\"font-weight: 400\"> is the value which needs to be formatted as money.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Format<\/span><span style=\"font-weight: 400\"> is the specific format which is system defined or mentioned by the user. If you do not specify a format in this function, then the date formats saved in the system as defaults are used. <\/span><\/p>\n<p><span style=\"font-weight: 400\">dec_sep<\/span><span style=\"font-weight: 400\"> is the string which specifies the decimal number separator. MoneyDecimalSep is used as the default decimal separator. <\/span><\/p>\n<p><span style=\"font-weight: 400\">thou_sep<\/span><span style=\"font-weight: 400\"> is the string which specifies the thousands number separator. MoneyThousandSep is used as the default thousand separator in the data load script. <\/span><\/p>\n<p><span style=\"font-weight: 400\"><strong>For example<\/strong>, in the piece of code given below, we have set a format for the numeric values as 0.00. <\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Sheet1:\r\nlet result= Num( pi( ), '0.00' );\r\nLoad * inline\r\n[Field1; Field2\r\n4; 12.56\r\n1; $(result)\r\n](delimiter is ';');<\/pre>\n<p>The results for the field <b>Field1<\/b> will be 4 and 1. Results for the field <b>Field2<\/b> will be 12.56 and 3.14 (value of pi) according to the format specified in the function.<\/p>\n<h3><span style=\"font-weight: 400\">vii. Time() function in Qlik Sense<\/span><\/h3>\n<p><span style=\"font-weight: 400\">The time() function returns a numeric value by formatting it as a time value. The default settings are hh:mm:ss in the system which is taken up if you do not specify a time format in the function expression.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-date-and-time-functions\/\">Let&#8217;s revise Qlik Sense Date and Time Functions<\/a><\/strong><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Time(number[, format])<\/pre>\n<p><span style=\"font-weight: 400\">Where, <\/span><span style=\"font-weight: 400\">number<\/span><span style=\"font-weight: 400\"> is the value upon which you want to apply the time format. And using the <\/span><span style=\"font-weight: 400\">format<\/span><span style=\"font-weight: 400\"> parameter, you can specify the format in which you wish time to get displayed. <\/span><\/p>\n<p><span style=\"font-weight: 400\">For example, you can assign the time format to the values in the variables. <\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Time( T )<\/pre>\n<p><span style=\"font-weight: 400\">where T=0.375<\/span><\/p>\n<p><span style=\"font-weight: 400\">Returns a string value corresponding to the numeric value for T= 0.375 which is 09:00:00 as time. <\/span><\/p>\n<h3><span style=\"font-weight: 400\">viii. Timestamp() function in Qlik Sense<\/span><\/h3>\n<p><span style=\"font-weight: 400\">This function formats a numeric value as a date and time timestamp. The value returns in dual format i.e. it interpret both as a string and numeric value. <\/span><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Timestamp(number[, format])<\/pre>\n<p><span style=\"font-weight: 400\">Where, <\/span><span style=\"font-weight: 400\">number<\/span><span style=\"font-weight: 400\"> is the numeric value which is to be formatted as a timestamp.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/\">Take a visit to Qlik Sense Mapping Functions<\/a><\/strong><\/p>\n<p><span style=\"font-weight: 400\">format<\/span><span style=\"font-weight: 400\"> is the specific format which you want to apply on the value to make it a timestamp. There are two types of formats i.e. YY-MM-DD hh:mm:ss and M\/D\/YY hh:mm:ss which are available in the system as default formats. You use these if you do not specify a format for timestamp. <\/span><\/p>\n<p><span style=\"font-weight: 400\">For example, <\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Timestamp(TS)<\/pre>\n<p><span style=\"font-weight: 400\">where TS=35648.375<\/span><\/p>\n<p><span style=\"font-weight: 400\">This will return two values, for each of the two default timestamp format. For YY-MM-DD hh:mm:ss format the result is, 97-08-06 09:00:00 (string) and 35648.375 (numeric). And for M\/D\/YY hh:mm:ss format the result is 8\/6\/97 09:00:00 (string) and 35648.375 (numeric).<\/span><\/p>\n<p>So, this was all in Qlik Sense Formatting 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\">Hence, in this Qlik Sense Formatting functions tutorial, we learned about all such functions which format a numeric value into a specific type string interpretation. Moreover, these Qlik Sense Formatting Functions are such functions which we use to apply very basic yet important formats on data values. It is important to format data values as it is due to formatting that we can define data in certain ways, such as time, date, money, interval etc. so that it is easy in interpretation.<\/span><\/p>\n<p>Share your valuable feedback on Qlik Sense Formatting Functions through comments.<\/p>\n<p><strong>See also &#8211;\u00a0<\/strong><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-conditional-functions\/\">Qlik Sense Conditional Functions<\/a><\/strong><\/p>\n<p><strong><a href=\"https:\/\/help.qlik.com\/en-US\/sense\/November2018\/Subsystems\/Hub\/Content\/Sense_Hub\/Scripting\/FormattingFunctions\/formatting-functions.htm\">Reference for Qlik Sense<\/a><\/strong><span hidden class=\"__iawmlf-post-loop-links\" data-iawmlf-links=\"[{&quot;id&quot;:1724,&quot;href&quot;:&quot;https:\\\/\\\/help.qlik.com\\\/en-US\\\/sense\\\/November2018\\\/Subsystems\\\/Hub\\\/Content\\\/Sense_Hub\\\/Scripting\\\/FormattingFunctions\\\/formatting-functions.htm&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20200813181957\\\/https:\\\/\\\/help.qlik.com\\\/en-US\\\/sense\\\/November2018\\\/Subsystems\\\/Hub\\\/Content\\\/Sense_Hub\\\/Scripting\\\/FormattingFunctions\\\/formatting-functions.htm&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-09 20:51:39&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-17 17:13:01&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-28 14:52:53&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-02 06:58:37&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-05 17:22:49&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-12 13:38:15&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-16 13:01:23&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-19 13:34:42&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-27 08:31:05&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-30 12:05:46&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-10 16:13:47&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-18 02:56:01&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-23 07:57:21&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-26 15:44:10&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-17 08:49:48&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-27 06:08:22&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-14 18:17:55&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-28 20:28:02&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-19 09:40:15&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-22 12:28:27&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-05-29 05:58:35&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-03 11:02:48&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-15 10:14:36&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-18 20:31:45&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-29 13:22:47&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-07-03 19:55:38&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-07-03 19:55:38&quot;,&quot;http_code&quot;:206},&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 interpretation Functions. Today, we will see Qlik Sense Formatting Functions. We use the formatting functions in Qlik Sense to format numeric values&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":42995,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[17674,17676,17680,17673,17677,17678,17675,17679],"class_list":["post-42869","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-formatting-functions-in-qlik-sense","tag-qlik-sense-date-function","tag-qlik-sense-dual-function","tag-qlik-sense-formatting-functions","tag-qlik-sense-interval-function","tag-qlik-sense-money-function","tag-qlik-sense-num-function","tag-qlik-sense-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 Formatting Functions - Syntax and Example - DataFlair<\/title>\n<meta name=\"description\" content=\"Qlik Sense Formatting functions, Applycodepage function, time function, money function, num function, interval function, dual 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-formatting-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Formatting Functions - Syntax and Example - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Qlik Sense Formatting functions, Applycodepage function, time function, money function, num function, interval function, dual function in Qlik Sense\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-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-21T06:16:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Formatting-Functions-01-2.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=\"9 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qlik Sense Formatting Functions - Syntax and Example - DataFlair","description":"Qlik Sense Formatting functions, Applycodepage function, time function, money function, num function, interval function, dual 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-formatting-functions\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Formatting Functions - Syntax and Example - DataFlair","og_description":"Qlik Sense Formatting functions, Applycodepage function, time function, money function, num function, interval function, dual function in Qlik Sense","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-functions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-21T06:16:25+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Formatting-Functions-01-2.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":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-functions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-functions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Formatting Functions &#8211; Syntax and Example","datePublished":"2018-11-21T06:16:25+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-functions\/"},"wordCount":1653,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Formatting-Functions-01-2.jpg","keywords":["Formatting Functions in Qlik sense","Qlik Sense Date Function","Qlik sense Dual Function","Qlik Sense Formatting Functions","Qlik Sense Interval Function","Qlik Sense Money Function","Qlik Sense Num Function","Qlik Sense Timestamp Function"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-functions\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-functions\/","name":"Qlik Sense Formatting Functions - Syntax and Example - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-functions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Formatting-Functions-01-2.jpg","datePublished":"2018-11-21T06:16:25+00:00","description":"Qlik Sense Formatting functions, Applycodepage function, time function, money function, num function, interval function, dual function in Qlik Sense","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-functions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Formatting-Functions-01-2.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Formatting-Functions-01-2.jpg","width":1200,"height":628,"caption":"Qlik Sense Formatting Functions"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-formatting-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 Formatting Functions &#8211; Syntax and 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\/42869","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=42869"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/42869\/revisions"}],"predecessor-version":[{"id":42996,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/42869\/revisions\/42996"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/42995"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=42869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=42869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=42869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}