

{"id":38928,"date":"2018-11-10T12:02:54","date_gmt":"2018-11-10T06:32:54","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=38928"},"modified":"2018-11-13T17:14:18","modified_gmt":"2018-11-13T11:44:18","slug":"qlikview-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-functions\/","title":{"rendered":"QlikView Functions &#8211; Complete List of Functions with Examples"},"content":{"rendered":"<h2 style=\"text-align: left\" align=\"center\">1. QlikView Functions &#8211; Objective<\/h2>\n<p>In our last tutorial, we study<a href=\"https:\/\/data-flair.training\/blogs\/qlikview-synthetic-keys\/\"><strong> QlikView\u00a0Synthetic Keys<\/strong><\/a>. Here, we will open a new chapter called QlikView Functions. There are total 21 functions in QlikView. Along with this, we will study a list of QlikView Functions with their syntax and examples.<\/p>\n<p><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">You can either apply these QlikView functions by typing them directly in the script editor where your script is loaded or you can select from an already fed list while creating a table box.<\/span><\/span><\/p>\n<p>So, let&#8217;s start QlikView Functions Tutorial.<\/p>\n<div id=\"attachment_38977\" style=\"width: 1214px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Functions-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38977\" class=\"size-full wp-image-38977\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Functions-01.jpg\" alt=\"QlikView Functions - Complete List of Functions with Examples\" width=\"1204\" height=\"629\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Functions-01.jpg 1204w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Functions-01-150x78.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Functions-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Functions-01-768x401.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Functions-01-1024x535.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Functions-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1204px) 100vw, 1204px\" \/><\/a><p id=\"caption-attachment-38977\" class=\"wp-caption-text\">QlikView Functions &#8211; Complete List of Functions with Examples<\/p><\/div>\n<h2 align=\"justify\">2. What are QlikView\u00a0Functions?<\/h2>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">QlikView Functions are used to perform mathematical as well as many other kinds of operations on the data stored in-memory of Qlikview. While creating a table box, you must remember that a dialogue box opens where you can enter the table\u2019s title and add fields from your source file to your table box. In the same dialogue box, at the bottom left, you will find a CALCULATION CONDITION option. When you go to the drop down menu you will have a new dialogue box EDIT EXPRESSION.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\"> In the bottom half of this window, go to the FUNCTIONS tab. There are two fields to now, FUNCTION CATEGORY and FUNCTION NAME. You can select from a long list of QlikView functions and once you select one of these, you can choose specific function name within a category. Now to apply the selected function upon your data you need to paste the expression on the upper half of the editor and modify the command according to your table fields.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-intervalmatch\/\">Do you know What is\u00a0QlikView IntervalMatch &amp; Match Function?<\/a><\/strong><\/p>\n<div id=\"attachment_38978\" style=\"width: 819px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/func1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38978\" class=\"size-full wp-image-38978\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/func1.png\" alt=\"QlikView Functions - Complete List of Functions with Examples\" width=\"809\" height=\"637\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/func1.png 809w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/func1-150x118.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/func1-300x236.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/func1-768x605.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/func1-520x409.png 520w\" sizes=\"auto, (max-width: 809px) 100vw, 809px\" \/><\/a><p id=\"caption-attachment-38978\" class=\"wp-caption-text\">QlikView Functions &#8211; Introduction<\/p><\/div>\n<h2 align=\"justify\">3. List of QlikView Functions<\/h2>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">Given below are all the QlikView functions category a user can choose.<\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Aggregation<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Color<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Conditional<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Counter Functions<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Date and Time<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Exponential and Logarithmic<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Financial<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Formatting<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">General Numeric<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Inter-record<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Logical Function<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Mapping Function<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Mathematical constants and parameter-free functions<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">None<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Null<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Number Interpretation<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Range<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Ranking<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">String<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">System<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Georgia, serif\"><span style=\"font-size: medium\">Trigonometric and Hyperbolic<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-join-functions\/\">Let&#8217;s Explore QlikView Join Functions and its Types<\/a><\/strong><\/p>\n<h2>4. Types of QlikView Functions<\/h2>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">In this part of the QlikView Functions Tutorial, we will understand the work of each function with example and syntax.<\/span><\/span><\/p>\n<h3 align=\"justify\">i. General Numeric Functions in QlikView<\/h3>\n<p>There are 18 subtypes of QlikView Functions:<\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>div(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x1 , x2<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Integer division. Both parameters are interpreted as real numbers, i.e. they do not have to be integers. The result is the integer part of the result of the arithmetic division, a real number.<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">div( 7,2 ) <\/span><span style=\"font-family: Verdana, serif\">returns 3<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>mod(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x1 , x2<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Mathematical modulus function. Both parameters must have integer values. <\/span><span style=\"font-family: Verdana, serif\"><i>x2 <\/i><\/span><span style=\"font-family: Verdana, serif\">must be greater than 0. The result is the non-negative remainder of an integer division.<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">mod( 7,2 ) <\/span><span style=\"font-family: Verdana, serif\">returns 1<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">mod( 7.5,2 ) <\/span><span style=\"font-family: Verdana, serif\">returns NULL<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">mod( 9,3 ) <\/span><span style=\"font-family: Verdana, serif\">returns 0<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">mod( -4,3 ) <\/span><span style=\"font-family: Verdana, serif\">returns 2<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>fmod(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x1 , x2<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Generalized modulus function. Both parameters are interpreted as real numbers, i.e. they do not have to be integers. The result is the remainder of the integer division, a real number.<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">fmod( 7,2 ) <\/span><span style=\"font-family: Verdana, serif\">returns 1<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">fmod( 7.5,2 ) <\/span><span style=\"font-family: Verdana, serif\">returns 1.5<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">fmod( 9,3 ) <\/span><span style=\"font-family: Verdana, serif\">returns 0<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">fmod( -4,3 ) <\/span><span style=\"font-family: Verdana, serif\">returns -1<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>ceil(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x [ , base [ , offset ]]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Rounding of <\/span><span style=\"font-family: Verdana, serif\"><i>x <\/i><\/span><span style=\"font-family: Verdana, serif\">upwards to the nearest multiple of <\/span><span style=\"font-family: Verdana, serif\"><i>base <\/i><\/span><span style=\"font-family: Verdana, serif\">with an offset of <\/span><span style=\"font-family: Verdana, serif\"><i>offset<\/i><\/span><span style=\"font-family: Verdana, serif\">. The result is a number.<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">ceil( 2.4 ) <\/span><span style=\"font-family: Verdana, serif\">returns 3<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">ceil( 2.6 ) <\/span><span style=\"font-family: Verdana, serif\">returns 3<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">ceil( 3.88 , 0.1 ) <\/span><span style=\"font-family: Verdana, serif\">returns 3.9<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">ceil( 3.88 , 5 ) <\/span><span style=\"font-family: Verdana, serif\">returns 5<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>floor(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x [ , base [ , offset ]]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Rounding of <\/span><span style=\"font-family: Verdana, serif\"><i>x <\/i><\/span><span style=\"font-family: Verdana, serif\">downwards to the nearest multiple of <\/span><span style=\"font-family: Verdana, serif\"><i>base <\/i><\/span><span style=\"font-family: Verdana, serif\">with an offset of <\/span><span style=\"font-family: Verdana, serif\"><i>offset<\/i><\/span><span style=\"font-family: Verdana, serif\">. The result is a number.<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">floor( 2.4 ) <\/span><span style=\"font-family: Verdana, serif\">returns 2<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">floor( 2.6 ) <\/span><span style=\"font-family: Verdana, serif\">returns 2<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">floor( 3.88 , 0.1 ) <\/span><span style=\"font-family: Verdana, serif\">returns 3.8<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>round(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x [ , step [ , offset ]]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Rounding of <\/span><span style=\"font-family: Verdana, serif\"><i>x <\/i><\/span><span style=\"font-family: Verdana, serif\">upwards or downwards <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">number of steps with an offset of <\/span><span style=\"font-family: Verdana, serif\"><i>offset<\/i><\/span><span style=\"font-family: Verdana, serif\">. A result is a number. If <\/span><span style=\"font-family: Verdana, serif\"><i>x <\/i><\/span><span style=\"font-family: Verdana, serif\">is exactly in the middle of an interval, it is rounded upwards. The function complies with the IEEE standard<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">64-bit floating point numbers.<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">round( 2.4 ) <\/span><span style=\"font-family: Verdana, serif\">returns 2<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">round( 2.6 ) <\/span><span style=\"font-family: Verdana, serif\">returns 3<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>fabs(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">The absolute value of <\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\">. The result is a positive number.<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">fabs( 2.4 ) <\/span><span style=\"font-family: Verdana, serif\">returns 2.4<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>numsum(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Returns the numeric sum of 1 to N arguments. As opposed to the + operator, <\/span><span style=\"font-family: Verdana, serif\"><b>numsum <\/b><\/span><span style=\"font-family: Verdana, serif\">will treat all nonnumeric values as 0.<\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-keep-functions\/\">Read about QlikView Join Functions<\/a><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">numsum( 1,2,4 ) <\/span><span style=\"font-family: Verdana, serif\">returns 7<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">numsum( 1,&#8217;xyz&#8217; ) <\/span><span style=\"font-family: Verdana, serif\">returns 1<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>numcount(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the number of numeric values found in 1 to N arguments<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">numcount( 1,2,4, ) <\/span><span style=\"font-family: Verdana, serif\">returns 3<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>numavg(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the numeric average of 1 to N arguments. If no numeric value is found, NULL is returned.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">numavg( 1,2,4 ) <\/span><span style=\"font-family: Verdana, serif\">returns 2.33333333<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>nummin(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the lowest numeric value of 1 to N arguments. If no numeric value is found, NULL is returned.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">nummin( 1,2,4 ) <\/span><span style=\"font-family: Verdana, serif\">returns 1<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>nummax(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the highest numeric value of 1 to N arguments. If no numeric value is found, NULL is returned.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">nummax( 1,2,4 ) <\/span><span style=\"font-family: Verdana, serif\">returns 4<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>fact(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>n<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the factorial of a positive integer <\/span><span style=\"font-family: Verdana, serif\"><i>n<\/i><\/span><span style=\"font-family: Verdana, serif\">. If the number <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">is not an integer it will be truncated. Non-positive numbers will return NULL.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">fact( 1 ) <\/span><span style=\"font-family: Verdana, serif\">returns 1<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>combin(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>n1<\/i><\/span><span style=\"font-family: Verdana, serif\">, <\/span><span style=\"font-family: Verdana, serif\"><i>n2<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the number of combinations of <\/span><span style=\"font-family: Verdana, serif\"><i>n2 <\/i><\/span><span style=\"font-family: Verdana, serif\">items that can be picked from a group of <\/span><span style=\"font-family: Verdana, serif\"><i>n1 <\/i><\/span><span style=\"font-family: Verdana, serif\">items. The order in which the items are selected is insignificant. Non-integer items will be truncated.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">How many combinations of 7 numbers can be picked from a total of 35 Lotto numbers?<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">combin( 35,7 ) <\/span><span style=\"font-family: Verdana, serif\">returns 6 724 520<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>even(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>n<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns true if <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">is an even integer, false if <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">is an odd integer and NULL if <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">is not an integer.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">even( 3 ) <\/span><span style=\"font-family: Verdana, serif\">returns false<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>odd(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>n<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns true if <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">is an odd integer, false if <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">is an even integer and NULL if <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">is not an integer.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">odd( 3 ) <\/span><span style=\"font-family: Verdana, serif\">returns true<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>sign(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns 1, 0 or -1 depending on whether <\/span><span style=\"font-family: Verdana, serif\"><i>x <\/i><\/span><span style=\"font-family: Verdana, serif\">is a number, 0 or a negative number. If no numeric value is found, NULL is returned.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">sign( 66 ) <\/span><span style=\"font-family: Verdana, serif\">returns 1<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>bitcount(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>i<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the number of set bits in <\/span><span style=\"font-family: Verdana, serif\"><i>i<\/i><\/span><span style=\"font-family: Verdana, serif\">. Where <\/span><span style=\"font-family: Verdana, serif\"><i>i <\/i><\/span><span style=\"font-family: Verdana, serif\">is interpreted as a signed 64-bit integer, though only the first 48 bits are significant. A value above 48-bits will return NULL.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">bitcount ( 3 ) <\/span><span style=\"font-family: Verdana, serif\">returns 2<\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/\">Follow the link to create QlikView Master Calendar<\/a><\/strong><\/p>\n<h3 align=\"justify\">ii. Range Functions in QlikView<\/h3>\n<p>Following are the 18 sub-types of Range QlikView Functions:<\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangesum(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the sum of a range of 1 to N arguments. As opposed to the <\/span><span style=\"font-family: Verdana, serif\"><b>+ <\/b><\/span><span style=\"font-family: Verdana, serif\">operator, <\/span><span style=\"font-family: Verdana, serif\"><b>rangesum <\/b><\/span><span style=\"font-family: Verdana, serif\">will treat all nonnumeric<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">values as 0.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangesum (1,2,4) <\/span><span style=\"font-family: Verdana, serif\">returns 7<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangeavg(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the average of a range of 1 to N arguments. If no numeric value is found, NULL is returned.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangeavg (1,2,4) <\/span><span style=\"font-family: Verdana, serif\">returns 2.33333333<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangecount(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the number of values found within a range of 1 to N arguments. NULL values are not counted.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangecount (1,2,4) <\/span><span style=\"font-family: Verdana, serif\">returns 3<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangemin(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the lowest numeric value found within a range 1 to N arguments. If no numeric value is found, NULL is returned.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangemin (1,2,4) <\/span><span style=\"font-family: Verdana, serif\">returns 1<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangemax(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the highest numeric values found within a range of 1 to N arguments. If no numeric value is found, NULL is returned.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangemax (1,2,4) <\/span><span style=\"font-family: Verdana, serif\">returns 4<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangestdev(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ] <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the standard deviation found within a range of 1 to N arguments. If no numeric value is found, NULL is returned.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangestdev (1,2,4) <\/span><span style=\"font-family: Verdana, serif\">returns 1.5275252316519<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangeskew(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the skewness within a range of 1 to N arguments. If no numeric value is found, NULL is returned.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangeskew (1,2,4) <\/span><span style=\"font-family: Verdana, serif\">returns 0.93521952958283<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangekurtosis(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the kurtosis within a range of 1 to N arguments. If no numeric value is found, NULL is returned.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangekurtosis (1,2,4,7) <\/span><span style=\"font-family: Verdana, serif\">returns -0.28571428571429<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangefractile(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>fractile, expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the fractile within a range of 1 to N arguments.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-data-load\/\">Have a look &#8211; Different ways to Implement Data Loading in QlikView<\/a><\/strong><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangefractile (0.24,1,2,4,6) <\/span><span style=\"font-family: Verdana, serif\">returns 1<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangenumericcount(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the number of numeric values found within a range of 1 to N arguments.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangenumericcount (1,2,4) <\/span><span style=\"font-family: Verdana, serif\">returns 3<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangetextcount(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the number of text values found within a range of 1 to N arguments.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">rangetextcount (1,2,4) <\/span><span style=\"font-family: Verdana, serif\">returns 0<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangetextcount (2,&#8217;xyz&#8217;) <\/span><span style=\"font-family: Verdana, serif\">returns 1<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangenullcount(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the number of NULL values found within a range of 1 to N arguments.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangenullcount (1,2,4) <\/span><span style=\"font-family: Verdana, serif\">returns 0<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangemissingcount(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the number of non-numeric values (including NULL values) found among 1 to N arguments.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangemissingcount (1,2,4) <\/span><span style=\"font-family: Verdana, serif\">returns 0<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangeminstring(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the first value in text sort order found among 1 to N arguments.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">rangeminstring (1,2,4) <\/span><span style=\"font-family: Verdana, serif\">returns 1<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangeminstring (&#8216;xyz&#8217;,&#8217;abc&#8217;) <\/span><span style=\"font-family: Verdana, serif\">returns &#8216;abc<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangemaxstring(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the last value in text sort order found among 1 to N arguments.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangemaxstring (1,2,4) <\/span><span style=\"font-family: Verdana, serif\">returns 4<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangemode(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the mode value, i.e. the most commonly occurring value within a range of 1 to N arguments. If more than one value shares the highest frequency, NULL is returned.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangemode (1,2,9,2,4) <\/span><span style=\"font-family: Verdana, serif\">returns 2<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangeonly(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr1 [ , expr2, &#8230; exprN ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">If exactly one non-NULL value exists among the range of N expressions, that value will be returned. In all other cases, NULL is returned.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangeonly (1,2,4) <\/span><span style=\"font-family: Verdana, serif\">returns NULL<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rangecorrel(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x-value , y-value { , x-value , y-value}<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the correlation coefficient for a series of coordinates.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><i>X-value <\/i><\/span><span style=\"font-family: Verdana, serif\">and <\/span><span style=\"font-family: Verdana, serif\"><i>y-value <\/i><\/span><span style=\"font-family: Verdana, serif\">are single values. Each <\/span><span style=\"font-family: Verdana, serif\"><i>y-value <\/i><\/span><span style=\"font-family: Verdana, serif\">must correspond to an <\/span><span style=\"font-family: Verdana, serif\"><i>x-value<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-use-cases\/\">Refer this &#8211; Which companies are using QlikView.<\/a><\/strong><\/p>\n<p><span style=\"font-family: Verdana, serif\">The function needs at least two pairs of coordinates to be calculated. Text values, null values and missing values are disregarded.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">rangecorrel (2,3,6,8,9,4) <\/span><span style=\"font-family: Verdana, serif\">returns 0,269<\/span><\/p>\n<h3 align=\"justify\">iii. Exponential and Logarithmic Functions in QlikView<\/h3>\n<p>Here, we will discuss 6 sub-types of QlikView Functions:<\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>exp(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Exponential function, with the base of the natural logarithm <\/span><span style=\"font-family: Verdana, serif\"><i>e <\/i><\/span><span style=\"font-family: Verdana, serif\">as base. A result is a positive number.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>log(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">The natural logarithm of <\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\">. The function is only defined if <\/span><span style=\"font-family: Verdana, serif\"><i>x <\/i><\/span><span style=\"font-family: Verdana, serif\">&gt; 0. A result is a number.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>log10(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">The 10-logarithm (base 10) of <\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\">. The function is only defined if <\/span><span style=\"font-family: Verdana, serif\"><i>x <\/i><\/span><span style=\"font-family: Verdana, serif\">&gt; 0. A result is a number.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>sqrt(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Square root of <\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\">. The function is only defined if <\/span><span style=\"font-family: Verdana, serif\"><i>x <\/i><\/span><span style=\"font-family: Verdana, serif\">&gt;= 0. A result is a positive number.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>sqr (<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><strong><span style=\"font-family: Verdana, serif\">)<\/span><\/strong><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Square of <\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\">. A result is a number.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>pow(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x,y<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Returns <\/span><span style=\"font-family: Verdana, serif\"><i>x <\/i><\/span><span style=\"font-family: Verdana, serif\">to the power of <\/span><span style=\"font-family: Verdana, serif\"><i>y<\/i><\/span><span style=\"font-family: Verdana, serif\">. A result is a number<\/span><\/p>\n<h3 align=\"justify\">iv. Trigonometric and Hyperbolic Functions in QlikView<\/h3>\n<p>Here, we will cover total 10 sub-types of QlikView Functions:<\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>cos(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Cosine of <\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\">. A result is a number between -1 and 1.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>acos(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Arcus cosine of <\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\">. The function is only defined if -1\u2264<\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\">\u22641. A result is a number between 0 and <\/span><span style=\"font-family: Verdana, serif\">p<\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>sin(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Sine of <\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\">. A result is a number between -1 and 1.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>asin(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Arcus sine of <\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\">. The function is only defined if -1\u2264<\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\">\u22641. A result is a number between &#8211; <\/span><span style=\"font-family: Verdana, serif\">p<\/span><span style=\"font-family: Verdana, serif\">\/2 and <\/span><span style=\"font-family: Verdana, serif\">p<\/span><span style=\"font-family: Verdana, serif\">\/2.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>tan(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Tangent of <\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\">. A result is a number.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>atan(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Arcus tangent of <\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\">. A result is a number between &#8211; <\/span><span style=\"font-family: Verdana, serif\">p<\/span><span style=\"font-family: Verdana, serif\">\/2 and <\/span><span style=\"font-family: Verdana, serif\">p<\/span><span style=\"font-family: Verdana, serif\">\/2.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>atan2(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>y,x<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Two-dimensional generalization of the arcus tangent function. Returns the angle between the origin and the\u00a0<\/span><span style=\"font-family: Verdana, serif\">point represented by the coordinates <\/span><span style=\"font-family: Verdana, serif\"><i>x <\/i><\/span><span style=\"font-family: Verdana, serif\">and <\/span><span style=\"font-family: Verdana, serif\"><i>y<\/i><\/span><span style=\"font-family: Verdana, serif\">. A result is a number between &#8211; <\/span><span style=\"font-family: Verdana, serif\">p <\/span><span style=\"font-family: Verdana, serif\">and + <\/span><span style=\"font-family: Verdana, serif\">p<\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>cosh(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Cosine hyberbolicus of x. A result is a positive number.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>sinh(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Sine hyberbolicus of <\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\">. A result is a number.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>tanh(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Tangent hyberbolicus of <\/span><span style=\"font-family: Verdana, serif\"><i>x<\/i><\/span><span style=\"font-family: Verdana, serif\">. A result is a number.<\/span><\/p>\n<h3>v. Financial Functions in QlikView<\/h3>\n<p>As the name says, these QlikView functions use in financial problems. We are going to explore total 5 sub-types of QlikView Financial Functions with their examples.<\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>fv(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>rate, nper, pmt [ ,pv [ , type ] ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the future value of an investment based on periodic, constant payments and a constant interest rate.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">The result has a default number format of <\/span><span style=\"font-family: Verdana, serif\"><i>Money<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">You are paying a new VCR by 36 monthly instalments of $20. The interest rate is 6% per annum.The bill comes at the end of every month. What is the total value of the money invested, when the last bill has been paid?<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">fv(0.005,36,-20) <\/span><span style=\"font-family: Verdana, serif\">returns $786.72<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>nper(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>rate, pmt, pv [ ,fv [ , type ] ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">You want to sell a VCR by monthly instalments of $20. The interest rate is 6% per annum. The bill comes at the end of every month. How many periods are required if the value of the money received after the last bill has been paid should equal $786.72?<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">nper(0.005,-20,0,800) <\/span><span style=\"font-family: Verdana, serif\">returns 36<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-november-2017\/\">Do you know the features of QlikView Version 12.2?<\/a><\/strong><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>pmt(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>rate, nper, pv [ ,fv [ , type ] ] <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the payment for a loan based on periodic, constant payments and a constant interest rate. The result has a default number format of <\/span><span style=\"font-family: Verdana, serif\"><i>Money.<\/i><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">To find the total amount paid over the duration of the loan, multiply the returned <\/span><span style=\"font-family: Verdana, serif\"><i>pmt <\/i><\/span><span style=\"font-family: Verdana, serif\">value by <\/span><span style=\"font-family: Verdana, serif\"><i>nper<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">The following formula returns the monthly payment on a $20,000 loan at an annual rate of 10 percent, that must be paid off in 8 months:<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">pmt(0.1\/12,8,20000) <\/span><span style=\"font-family: Verdana, serif\">returns -$2,594.66<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">For the same loan, if payment is due at the beginning of the period, the payment is:<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">pmt(0.1\/12,8,20000,0,1) <\/span><span style=\"font-family: Verdana, serif\">returns -$2,573.21<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">316<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>pv(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>rate, nper, pmt [ ,fv [ , type ] ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the present value of an investment. The result has a default number format of <\/span><span style=\"font-family: Verdana, serif\"><i>Money .<\/i><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">The present value is the total amount that a series of future payments is worth right now. For example, when borrowing money, the loan amount is the present value to the lender.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">What is the present value of $100 paid to you at the end of each month during a 5 year period, given an interest rate of 7%?<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">pv(0.07\/12,12*5,100,0,0) <\/span><span style=\"font-family: Verdana, serif\">returns -$5,050.20<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rate(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>nper, pmt , pv [ ,fv [ , type ] ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the interest rate per period on annuity. The result has a default number format of <\/span><span style=\"font-family: Verdana, serif\"><b>Fix <\/b><\/span><span style=\"font-family: Verdana, serif\">two decimals and %.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">The <\/span><span style=\"font-family: Verdana, serif\"><i>rate <\/i><\/span><span style=\"font-family: Verdana, serif\">is calculated by iteration and can have zero or more solutions. If the successive results of <\/span><span style=\"font-family: Verdana, serif\"><i>rate <\/i><\/span><span style=\"font-family: Verdana, serif\">do not converge, a NULL value will be returned.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">What is the interest rate of a five-year $10,000 annuity loan with monthly payments of $300?<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><b>rate(60,-300,10000) <\/b><\/span><span style=\"font-family: Verdana, serif\">returns 2.18%<\/span><\/p>\n<h3 align=\"justify\">vi. Mathematical Constants and Parameter-Free Functions in QlikView<\/h3>\n<p><span style=\"font-family: Verdana, serif\">These QlikView Functions do not have any parameters. The parentheses are however still required.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>e( )<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Base of the natural logarithms, <\/span><span style=\"font-family: Verdana, serif\"><i>e<\/i><\/span><span style=\"font-family: Verdana, serif\">. The function returns 2.71828&#8230;<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>pi( )<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">The function returns 3.14159&#8230;<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rand( )<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns a random number between 0 and 1.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>true( )<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns a dual value with text value &#8216;true&#8217; and numeric value -1, which can be used as logical true in expressions.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>false( )<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Returns a dual value with text value &#8216;false&#8217; and numeric value 0, which can be used as logically false<\/span><span style=\"font-family: TimesNewRomanPSMT, serif\"><span style=\"font-size: small\">.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-dashboard\/\">Follow this link to Create QlikView Dashboard<\/a><\/strong><\/p>\n<h3 align=\"justify\">vii. String Functions in QlikView<\/h3>\n<p><span style=\"font-family: Verdana, serif\">The parameters are expressions where <\/span><span style=\"font-family: Verdana, serif\"><i>s <\/i><\/span><span style=\"font-family: Verdana, serif\">should be interpreted as a string. Here, we will discuss the total 18 subtypes of QlikView Functions:<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>ord(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>s<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">ASCII number of first character of string <\/span><span style=\"font-family: Verdana, serif\"><i>s<\/i><\/span><span style=\"font-family: Verdana, serif\">. The result is an integer.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">ord(&#8216;A&#8217;) <\/span><span style=\"font-family: Verdana, serif\">returns the number <\/span><span style=\"font-family: Verdana, serif\"><i>65<\/i><\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>chr(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>n<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">The ASCII character corresponding to number <\/span><span style=\"font-family: Verdana, serif\"><i>n<\/i><\/span><span style=\"font-family: Verdana, serif\">. The result is a string.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">chr(65) <\/span><span style=\"font-family: Verdana, serif\">returns the string <\/span><span style=\"font-family: Verdana, serif\"><i>&#8216;A&#8217;<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>len(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>s<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Length of string <\/span><span style=\"font-family: Verdana, serif\"><i>s<\/i><\/span><span style=\"font-family: Verdana, serif\">. The result is an integer.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">len(Name) <\/span><span style=\"font-family: Verdana, serif\">where <\/span><span style=\"font-family: Verdana, serif\"><i>Name <\/i><\/span><span style=\"font-family: Verdana, serif\">= &#8216;Peter&#8217; returns <\/span><span style=\"font-family: Verdana, serif\"><i>5<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>left(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>s , n<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">A substring of the string <\/span><span style=\"font-family: Verdana, serif\"><i>s<\/i><\/span><span style=\"font-family: Verdana, serif\">. The result is a string consisting of the first <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">characters of <\/span><span style=\"font-family: Verdana, serif\"><i>s<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">left(&#8216;abcdef&#8217;,3) <\/span><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>&#8216;abc&#8217;<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>right(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>s , n<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Substring of the string <\/span><span style=\"font-family: Verdana, serif\"><i>s<\/i><\/span><span style=\"font-family: Verdana, serif\">. The result is a string consisting of the last <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">characters of <\/span><span style=\"font-family: Verdana, serif\"><i>s<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">right(&#8216;abcdef&#8217;,3 ) <\/span><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>&#8216;def&#8217;<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>mid(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>s, n1[, n2 ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Substring of the string <\/span><span style=\"font-family: Verdana, serif\"><i>s<\/i><\/span><span style=\"font-family: Verdana, serif\">. The result is the string starting at character <\/span><span style=\"font-family: Verdana, serif\"><i>n1 <\/i><\/span><span style=\"font-family: Verdana, serif\">with the length of <\/span><span style=\"font-family: Verdana, serif\"><i>n2 <\/i><\/span><span style=\"font-family: Verdana, serif\">characters. If <\/span><span style=\"font-family: Verdana, serif\"><i>n2 <\/i><\/span><span style=\"font-family: Verdana, serif\">is omitted, the function returns the rightmost part of the string starting at character <\/span><span style=\"font-family: Verdana, serif\"><i>n1<\/i><\/span><span style=\"font-family: Verdana, serif\">. The positions in the string are numbered from <\/span><span style=\"font-family: Verdana, serif\"><i>1 <\/i><\/span><span style=\"font-family: Verdana, serif\">and up.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">mid(&#8216;abcdef&#8217;,3 ) <\/span><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>&#8216;cdef&#8217;<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">mid(&#8216;abcdef&#8217;,3, 2 ) <\/span><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>&#8216;cd&#8217;<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>index(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>s1 , s2[ , n]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">A position of a substring. This function gives the starting position of the <\/span><span style=\"font-family: Verdana, serif\"><i>n<\/i><\/span><span style=\"font-family: Verdana, serif\">:th occurrence of substring <\/span><span style=\"font-family: Verdana, serif\"><i>s2 <\/i><\/span><span style=\"font-family: Verdana, serif\">in string <\/span><span style=\"font-family: Verdana, serif\"><i>s1<\/i><\/span><span style=\"font-family: Verdana, serif\">. If <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">is omitted, the first occurrence is assumed. If <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">is negative, the search is made starting from the end of string <\/span><span style=\"font-family: Verdana, serif\"><i>s1<\/i><\/span><span style=\"font-family: Verdana, serif\">. The result is an integer. The positions in the string are numbered from <\/span><span style=\"font-family: Verdana, serif\"><i>1 <\/i><\/span><span style=\"font-family: Verdana, serif\">and up.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">index( &#8216;abcdefg&#8217;, &#8216;cd&#8217; ) <\/span><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>3<\/i><\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>upper(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>textexpression<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Forces upper case for all data in the expression.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">upper( &#8216;abcD&#8217; ) <\/span><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>&#8216;ABCD&#8217;<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>lower( <\/b><\/span><span style=\"font-family: Verdana, serif\"><i>textexpression <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Forces lower case for all data in the expression.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">lower( &#8216;abcD&#8217; ) <\/span><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>&#8216;abcd&#8217;<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>repeat( <\/b><\/span><span style=\"font-family: Verdana, serif\"><i>s, n<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Forms a string consisting of the string <\/span><span style=\"font-family: Verdana, serif\"><i>s <\/i><\/span><span style=\"font-family: Verdana, serif\">repeated <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">times.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">repeat( &#8216; * &#8216;, rating ) <\/span><span style=\"font-family: Verdana, serif\">when <\/span><span style=\"font-family: Verdana, serif\"><i>rating <\/i><\/span><span style=\"font-family: Verdana, serif\">= 4 returns &#8216;<\/span><span style=\"font-family: Verdana, serif\"><i>****<\/i><\/span><span style=\"font-family: Verdana, serif\">&#8216;.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>ltrim(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>s <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the string <\/span><span style=\"font-family: Verdana, serif\"><i>s <\/i><\/span><span style=\"font-family: Verdana, serif\">trimmed of any leading spaces.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">ltrim ( &#8216; abc&#8217; ) <\/span><span style=\"font-family: Verdana, serif\">returns &#8216;<\/span><span style=\"font-family: Verdana, serif\"><i>abc<\/i><\/span><span style=\"font-family: Verdana, serif\">&#8216;.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">ltrim ( &#8216;abc &#8216; ) <\/span><span style=\"font-family: Verdana, serif\">returns &#8216;<\/span><span style=\"font-family: Verdana, serif\"><i>abc <\/i><\/span><span style=\"font-family: Verdana, serif\">&#8216;<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>rtrim(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>s <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the string s trimmed of any trailing spaces.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">rtrim ( &#8216; abc&#8217; ) <\/span><span style=\"font-family: Verdana, serif\">returns &#8216; <\/span><span style=\"font-family: Verdana, serif\"><i>abc<\/i><\/span><span style=\"font-family: Verdana, serif\">&#8216;<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">rtrim ( &#8216;abc &#8216; ) <\/span><span style=\"font-family: Verdana, serif\">returns &#8216;<\/span><span style=\"font-family: Verdana, serif\"><i>abc<\/i><\/span><span style=\"font-family: Verdana, serif\">&#8216;<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>trim(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>s <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the string <\/span><span style=\"font-family: Verdana, serif\"><i>s <\/i><\/span><span style=\"font-family: Verdana, serif\">trimmed of any leading and trailing spaces.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-scripting\/\">Let&#8217;s Explore &#8211; QlikView Scripting and Features of Script Editor<\/a><\/strong><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">trim ( &#8216; abc&#8217; ) <\/span><span style=\"font-family: Verdana, serif\">returns &#8216;<\/span><span style=\"font-family: Verdana, serif\"><i>abc<\/i><\/span><span style=\"font-family: Verdana, serif\">&#8216;<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">trim ( &#8216;abc &#8216; ) <\/span><span style=\"font-family: Verdana, serif\">returns &#8216;<\/span><span style=\"font-family: Verdana, serif\"><i>abc<\/i><\/span><span style=\"font-family: Verdana, serif\">&#8216;<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">trim ( &#8216; abc &#8216; ) <\/span><span style=\"font-family: Verdana, serif\">returns &#8216;<\/span><span style=\"font-family: Verdana, serif\"><i>abc<\/i><\/span><span style=\"font-family: Verdana, serif\">&#8216;<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>KeepChar(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>s1 , s2<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the string <\/span><span style=\"font-family: Verdana, serif\"><i>s1 <\/i><\/span><span style=\"font-family: Verdana, serif\">less all characters not contained in string <\/span><span style=\"font-family: Verdana, serif\"><i>s2<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">keepchar ( &#8216;a1b2c3&#8242;,&#8217;123&#8217; ) <\/span><span style=\"font-family: Verdana, serif\">returns &#8216;<\/span><span style=\"font-family: Verdana, serif\"><i>123&#8242;<\/i><\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>PurgeChar(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>s1, s2<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the string <\/span><span style=\"font-family: Verdana, serif\"><i>s1 <\/i><\/span><span style=\"font-family: Verdana, serif\">less all characters contained in string <\/span><span style=\"font-family: Verdana, serif\"><i>s2<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">purgechar ( &#8216;a1b2c3&#8242;,&#8217;123&#8217; ) <\/span><span style=\"font-family: Verdana, serif\">returns &#8216;<\/span><span style=\"font-family: Verdana, serif\"><i>abc<\/i><\/span><span style=\"font-family: Verdana, serif\">&#8216;<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>capitalize(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>s <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the string <\/span><span style=\"font-family: Verdana, serif\"><i>s <\/i><\/span><span style=\"font-family: Verdana, serif\">with all words capitalized.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">capitalize (&#8216;my little pony&#8217;) <\/span><span style=\"font-family: Verdana, serif\">returns &#8216;<\/span><span style=\"font-family: Verdana, serif\"><i>My Little Pony<\/i><\/span><span style=\"font-family: Verdana, serif\">&#8216;<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>evaluate(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>s <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">If the text string <\/span><span style=\"font-family: Verdana, serif\"><i>s <\/i><\/span><span style=\"font-family: Verdana, serif\">can be evaluated as a valid QlikView expression, the evaluated result of the expression will be returned. If <\/span><span style=\"font-family: Verdana, serif\"><i>s <\/i><\/span><span style=\"font-family: Verdana, serif\">is not a valid expression, NULL is returned<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">evaluate ( 5 * 8 ) <\/span><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>40<\/i><\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>TextBetween(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>s , beforetext , aftertext [, n ]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the text between the <\/span><span style=\"font-family: Verdana, serif\"><i>n<\/i><\/span><span style=\"font-family: Verdana, serif\">:th occurrence of <\/span><span style=\"font-family: Verdana, serif\"><i>beforetext <\/i><\/span><span style=\"font-family: Verdana, serif\">and the immediately following occurrence of <\/span><span style=\"font-family: Verdana, serif\"><i>aftertext <\/i><\/span><span style=\"font-family: Verdana, serif\">within the string <\/span><span style=\"font-family: Verdana, serif\"><i>s<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">TextBetween(&#8216;&lt;abc&gt;&#8217;, &#8216;&lt;&#8216;, &#8216;&gt;&#8217;) <\/span><span style=\"font-family: Verdana, serif\">returns &#8216;<\/span><span style=\"font-family: Verdana, serif\"><i>abc<\/i><\/span><\/p>\n<h3>viii. Mapping Functions in QlikView<\/h3>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>applymap(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>&#8216;mapname&#8217;, expr [ , defaultexpr ] <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">where:<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><i>mapname <\/i><\/span><span style=\"font-family: Verdana, serif\">is the name of a mapping table that has previously been created through the <\/span><span style=\"font-family: Verdana, serif\"><b>mapping load.<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><i>expr <\/i><\/span><span style=\"font-family: Verdana, serif\">is the expression, the result of which should be mapped.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><i>defaultexpr <\/i><\/span><span style=\"font-family: Verdana, serif\">is an optional expression which will be used as a default mapping value if the mapping table<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">does not contain a matching value for <\/span><span style=\"font-family: Verdana, serif\"><i>expr<\/i><\/span><span style=\"font-family: Verdana, serif\">. <\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">\/\/ Assume the following mapping table:<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">map1:<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">mapping load * inline [<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">x, y<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">1, one<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">2, two<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">3, three ] ;<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">ApplyMap (&#8216;map1&#8217;, 2 ) <\/span><span style=\"font-family: Verdana, serif\">returns &#8216; two&#8217;<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>mapsubstring(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>&#8216;mapname&#8217;, expr<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">The <\/span><span style=\"font-family: Verdana, serif\"><b>MapSubstring <\/b><\/span><span style=\"font-family: Verdana, serif\">function is used to map parts of any expression to a previously loaded mapping table.<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">The mapping is case sensitive and non-iterative and substrings are mapped from left to right.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">\/\/ Assume the following mapping table:<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">map1:<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">mapping load * inline [<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">x, y<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">1, &lt;one&gt;<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">aa, XYZ<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">x, b ] ;<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">MapSubstring (&#8216;map1&#8217;, &#8216;A123&#8217;) <\/span><span style=\"font-family: Verdana, serif\">returns &#8216;A&lt;one&gt;23&#8217;<\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-set-analysis\/\">Also, Read &#8211;\u00a0QlikView Set Analysis\u00a0<\/a><\/strong><\/p>\n<h3 align=\"justify\">ix. Inter Record Functions in QlikView<\/h3>\n<p><span style=\"font-family: Verdana, serif\">These QlikView functions are used when a value from previously loaded records of data is needed for the evaluation of the current record.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>exists(<\/b><\/span><span style=\"font-family: Verdana, serif\">field [ , expression ]<\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Determines whether a specific field value exists in a specified field of the data loaded so far.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">exists(Month, &#8216;Jan&#8217;) <\/span><span style=\"font-family: Verdana, serif\">returns -1 (true) if the field value <\/span><span style=\"font-family: Verdana, serif\"><i>&#8216;Jan&#8217; <\/i><\/span><span style=\"font-family: Verdana, serif\">is found in the current content of<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">the field <\/span><span style=\"font-family: Verdana, serif\"><i>Month<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>previous(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expression <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the value of <\/span><span style=\"font-family: Verdana, serif\"><i>expression <\/i><\/span><span style=\"font-family: Verdana, serif\">using data from the previous input record that was not discarded due to a <\/span><span style=\"font-family: Verdana, serif\"><b>where <\/b><\/span><span style=\"font-family: Verdana, serif\">clause.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">Load *, Sales \/ previous(Sales) as Increase from &#8230;;<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Load A, previous(previous( A )) as B from &#8230;;<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>peek(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>fieldname [ , row [ , tablename ] ] <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the contents of the <\/span><span style=\"font-family: Verdana, serif\"><i>fieldname <\/i><\/span><span style=\"font-family: Verdana, serif\">in the record specified by <\/span><span style=\"font-family: Verdana, serif\"><i>row <\/i><\/span><span style=\"font-family: Verdana, serif\">in the internal table <\/span><span style=\"font-family: Verdana, serif\"><i>tablename<\/i><\/span><span style=\"font-family: Verdana, serif\">. Data are fetched from the associative QlikView database.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">peek( &#8216;Sales&#8217; )<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">returns the value of <\/span><span style=\"font-family: Verdana, serif\"><i>Sales <\/i><\/span><span style=\"font-family: Verdana, serif\">in the previous record read ( equivalent to <\/span><span style=\"font-family: Verdana, serif\">previous<\/span><span style=\"font-family: Verdana, serif\"><b>(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>Sales<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>FieldValue(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>fieldname , n <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the field value found in position <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">of the field <\/span><span style=\"font-family: Verdana, serif\"><i>fieldname <\/i><\/span><span style=\"font-family: Verdana, serif\">(by load order). <\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">FieldValue( &#8216;HelpText&#8217;, 5 )<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>FieldIndex(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>fieldname , value <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the position of the field value <\/span><span style=\"font-family: Verdana, serif\"><i>value <\/i><\/span><span style=\"font-family: Verdana, serif\">found in the field <\/span><span style=\"font-family: Verdana, serif\"><i>fieldname <\/i><\/span><span style=\"font-family: Verdana, serif\">(by load order). <\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">FieldIndex( &#8216;Name&#8217;, &#8216;John Doe&#8217; )<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>lookup(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>fieldname, matchfieldname, matchfieldvalue [, tablename]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the value of <\/span><span style=\"font-family: Verdana, serif\"><i>fieldname <\/i><\/span><span style=\"font-family: Verdana, serif\">corresponding to the first occurrence of the value <\/span><span style=\"font-family: Verdana, serif\"><i>matchfieldvalue <\/i><\/span><span style=\"font-family: Verdana, serif\">in the field<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">lookup(&#8216;Price&#8217;, &#8216;ProductID&#8217;, InvoicedProd, &#8216;pricelist&#8217;)<\/span><\/p>\n<h3 align=\"justify\">x. Conditional Functions in QlikView<\/h3>\n<p>7 sub-types of QlikView Functions are discussed below, let&#8217;s study them with their examples:<\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>if(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>condition , then , else<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">The three parameters <\/span><span style=\"font-family: Verdana, serif\"><i>condition<\/i><\/span><span style=\"font-family: Verdana, serif\">, <\/span><span style=\"font-family: Verdana, serif\"><i>then <\/i><\/span><span style=\"font-family: Verdana, serif\">and <\/span><span style=\"font-family: Verdana, serif\"><i>else <\/i><\/span><span style=\"font-family: Verdana, serif\">are all expressions. The first one, <\/span><span style=\"font-family: Verdana, serif\"><i>condition<\/i><\/span><span style=\"font-family: Verdana, serif\">, is interpreted logically. The two other ones, <\/span><span style=\"font-family: Verdana, serif\"><i>then <\/i><\/span><span style=\"font-family: Verdana, serif\">and <\/span><span style=\"font-family: Verdana, serif\"><i>else<\/i><\/span><span style=\"font-family: Verdana, serif\">, can be of any type.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">if( Amount&gt;= 0, &#8216;OK&#8217;, &#8216;Alarm&#8217; )<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>alt(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>case1[ , case2 , case3 , &#8230;] , else<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">The <\/span><span style=\"font-family: Verdana, serif\"><b>alt <\/b><\/span><span style=\"font-family: Verdana, serif\">function returns the first of the parameters that has a valid number representation. If no such match is found, the last parameter will be returned. Any number of parameters can be used.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">alt( date#( dat , &#8216;YYYY\/MM\/DD&#8217; )<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>pick(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>n, expr1[ , expr2,&#8230;exprN]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the <\/span><span style=\"font-family: Verdana, serif\"><i>n<\/i><\/span><span style=\"font-family: Verdana, serif\">th expression in the list. <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">is an integer between 1 and <\/span><span style=\"font-family: Verdana, serif\"><i>N<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">pick( N&#8217;A&#8221;B&#8217;4, , , )<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>&#8216;B&#8217; <\/i><\/span><span style=\"font-family: Verdana, serif\">if <\/span><span style=\"font-family: Verdana, serif\"><i>N <\/i><\/span><span style=\"font-family: Verdana, serif\">= <\/span><span style=\"font-family: Verdana, serif\"><i>2<\/i><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>4 <\/i><\/span><span style=\"font-family: Verdana, serif\">if <\/span><span style=\"font-family: Verdana, serif\"><i>N <\/i><\/span><span style=\"font-family: Verdana, serif\">= <\/span><span style=\"font-family: Verdana, serif\"><i>3<\/i><\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>match( <\/b><\/span><span style=\"font-family: Verdana, serif\"><i>str, expr1 [ , expr2,&#8230;exprN ] <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">The <\/span><span style=\"font-family: Verdana, serif\"><b>match <\/b><\/span><span style=\"font-family: Verdana, serif\">function performs a case sensitive comparison<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">match( M, &#8216;Jan&#8217;,&#8217;Feb&#8217;,&#8217;Mar&#8217;)<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>2 <\/i><\/span><span style=\"font-family: Verdana, serif\">if <\/span><span style=\"font-family: Verdana, serif\"><i>M <\/i><\/span><span style=\"font-family: Verdana, serif\">= <\/span><span style=\"font-family: Verdana, serif\"><i>Feb<\/i><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>0 <\/i><\/span><span style=\"font-family: Verdana, serif\">if <\/span><span style=\"font-family: Verdana, serif\"><i>M <\/i><\/span><span style=\"font-family: Verdana, serif\">= <\/span><span style=\"font-family: Verdana, serif\"><i>Apr <\/i><\/span><span style=\"font-family: Verdana, serif\">or <\/span><span style=\"font-family: Verdana, serif\"><i>Jan<\/i><\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/\">Let&#8217;s Revise QlikView Database Connection &amp; Inline Data<\/a><\/strong><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>mixmatch( <\/b><\/span><span style=\"font-family: Verdana, serif\"><i>str, expr1 [ , expr2,&#8230;exprN ] <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">The <\/span><span style=\"font-family: Verdana, serif\"><b>mixmatch <\/b><\/span><span style=\"font-family: Verdana, serif\">function performs a case insensitive comparison.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">mixmatch( M, &#8216;Jan&#8217;,&#8217;Feb&#8217;,&#8217;Mar&#8217;)<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>1 <\/i><\/span><span style=\"font-family: Verdana, serif\">if <\/span><span style=\"font-family: Verdana, serif\"><i>M <\/i><\/span><span style=\"font-family: Verdana, serif\">= <\/span><span style=\"font-family: Verdana, serif\"><i>Jan<\/i><\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>wildmatch( <\/b><\/span><span style=\"font-family: Verdana, serif\"><i>str, expr1 [ , expr2,&#8230;exprN ] <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">The <\/span><span style=\"font-family: Verdana, serif\"><b>wildmatch <\/b><\/span><span style=\"font-family: Verdana, serif\">function performs a case insensitive comparison and permits the use of wildcard characters (<\/span><span style=\"font-family: Verdana, serif\"><b>* <\/b><\/span><span style=\"font-family: Verdana, serif\">and <\/span><span style=\"font-family: Verdana, serif\"><b>?<\/b><\/span><span style=\"font-family: Verdana, serif\">) in the comparison strings.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">wildmatch( M, &#8216;ja*&#8217;,&#8217;fe?&#8217;,&#8217;mar&#8217;)<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>1 <\/i><\/span><span style=\"font-family: Verdana, serif\">if <\/span><span style=\"font-family: Verdana, serif\"><i>M <\/i><\/span><span style=\"font-family: Verdana, serif\">= <\/span><span style=\"font-family: Verdana, serif\"><i>January<\/i><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>2 <\/i><\/span><span style=\"font-family: Verdana, serif\">if <\/span><span style=\"font-family: Verdana, serif\"><i>M <\/i><\/span><span style=\"font-family: Verdana, serif\">= <\/span><span style=\"font-family: Verdana, serif\"><i>fex<\/i><\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>class(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expression, interval [ , label [ , offset ]]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Creates a classification of <\/span><span style=\"font-family: Verdana, serif\"><i>expressions<\/i><\/span><span style=\"font-family: Verdana, serif\">. <\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">class( var,10 ) <\/span><span style=\"font-family: Verdana, serif\">with <\/span><span style=\"font-family: Verdana, serif\"><i>var <\/i><\/span><span style=\"font-family: Verdana, serif\">= 23 returns <\/span><span style=\"font-family: Verdana, serif\"><i>&#8217;20&lt;=x&lt;30&#8242;<\/i><\/span><\/p>\n<h3>xi. Logical Functions in QlikView<\/h3>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>IsNum( <\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns -1 (true) if the expression can be interpreted as a number, otherwise 0 (false).<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>IsText(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns -1 (true) if the expression has a text representation, otherwise 0 (false).<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>IsPartialReload( )<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns &#8211; 1 (true) if the current reload is partial, otherwise 0 (false).<\/span><\/p>\n<h3>xii. NULL Functions in QlikView<\/h3>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>Null( )<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns a real NULL value.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>IsNull(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Returns -1 (true) if expr returns NULL, otherwise 0 (false).<\/span><\/p>\n<h3 align=\"justify\">xiii. Date and Time Functions in QlikView<\/h3>\n<p>Total 17 sub-types of QlikView functions are discussed below:<\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>second(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Second. Returns an integer representing the second when the fraction of <\/span><span style=\"font-family: Verdana, serif\"><i>expr <\/i><\/span><span style=\"font-family: Verdana, serif\">is interpreted as a time according to the standard number interpretation.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">second( &#8217;09:14:36&#8242; ) <\/span><span style=\"font-family: Verdana, serif\">returns 36<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>minute(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Minute. Returns an integer representing the minute when the fraction of <\/span><span style=\"font-family: Verdana, serif\"><i>expr <\/i><\/span><span style=\"font-family: Verdana, serif\">is interpreted as a time according to the standard number interpretation.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">minute( &#8217;09:14:36&#8242; ) <\/span><span style=\"font-family: Verdana, serif\">returns 14<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>hour(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>expr<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Hour. Returns an integer representing the hour when the fraction of <\/span><span style=\"font-family: Verdana, serif\"><i>expr <\/i><\/span><span style=\"font-family: Verdana, serif\">is interpreted as a time according to the standard number interpretation.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">hour( &#8217;09:14:36&#8242; ) <\/span><span style=\"font-family: Verdana, serif\">returns 9<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>day(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>date<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Day. Returns an integer representing the day when the fraction of <\/span><span style=\"font-family: Verdana, serif\"><i>expr <\/i><\/span><span style=\"font-family: Verdana, serif\">is interpreted as a date according to the standard number interpretation.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">day( &#8216;1971-10-30&#8217; ) <\/span><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>30<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>week(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>date<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Week number. Returns an integer representing the week<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">week( &#8216;1971-10-30&#8217; ) <\/span><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>43<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>month(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>date<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">month( &#8216;1971-10-30&#8217; ) <\/span><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>Oct<\/i><\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>year(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>date<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">year( &#8216;1971-10-30&#8217; ) <\/span><span style=\"font-family: Verdana, serif\">returns 1971.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>weekyear(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>date<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">The year to which the week number belongs<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">weekyear( &#8216;1996-12-30&#8217; ) <\/span><span style=\"font-family: Verdana, serif\">returns <\/span><span style=\"font-family: Verdana, serif\"><i>1997<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-documents\/\">Refer this &#8211;\u00a0Properties of QlikView Documents<\/a><\/strong><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>now(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>[ timer_mode]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Returns a timestamp of the current time from the system clock<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>today(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>[timer_mode] <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Returns the current date from the system clock<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>LocalTime(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>[timezone [, ignoreDST ]]<\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Returns a <\/span><span style=\"font-family: Verdana, serif\"><i>timestamp <\/i><\/span><span style=\"font-family: Verdana, serif\">of the current time from the system clock for a specified time zone<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">localtime (&#8216;Paris&#8217;)<\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">localtime (&#8216;GMT+01:00&#8217;)<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>MakeDate(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>YYYY [ , MM [ , DD ] ] <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">Returns a date calculated from the year <\/span><span style=\"font-family: Verdana, serif\"><i>YYYY<\/i><\/span><span style=\"font-family: Verdana, serif\">, the month <\/span><span style=\"font-family: Verdana, serif\"><i>MM <\/i><\/span><span style=\"font-family: Verdana, serif\">and the day <\/span><span style=\"font-family: Verdana, serif\"><i>DD<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">makeweekdate(1999,6,6) <\/span><span style=\"font-family: Verdana, serif\">returns 1999-02-14<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>AddMonths(<\/b><\/span><span style=\"font-family: Verdana, serif\"><i>startdate<\/i><\/span><span style=\"font-family: Verdana, serif\">, <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">, <\/span><span style=\"font-family: Verdana, serif\"><i>[ , mode] <\/i><\/span><span style=\"font-family: Verdana, serif\"><b>)<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the date occurring <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">months after <\/span><span style=\"font-family: Verdana, serif\"><i>start date <\/i><\/span><span style=\"font-family: Verdana, serif\">or, if <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">is negative, the date occurring <\/span><span style=\"font-family: Verdana, serif\"><i>n <\/i><\/span><span style=\"font-family: Verdana, serif\">months before <\/span><span style=\"font-family: Verdana, serif\"><i>start date<\/i><\/span><span style=\"font-family: Verdana, serif\">.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Examples:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">addmonths (&#8216;2003-01-29&#8217;,3) <\/span><span style=\"font-family: Verdana, serif\">returns &#8216;2003-04-29&#8217;<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>TimeZone( )<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the name of the current time zone, as defined in Windows.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">timezone( )<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>GMT( )<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the current Greenwich Mean Time, as derived from the system clock and Windows time settings.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">gmt( )<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>UTC( )<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the current Coordinated Universal Time.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\">utc( )<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Verdana, serif\"><b>DaylightSaving( )<\/b><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Verdana, serif\">Returns the current adjustment for daylight saving time, as defined in Windows.<\/span><\/p>\n<p><span style=\"font-family: Verdana, serif\"><b>Example:<\/b><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\">daylightsaving( )<\/span><\/p>\n<p align=\"justify\">So, this was all about QlikView Functions Tutorial. Hope you like our explanation.<\/p>\n<h2 align=\"justify\">5. Conclusion<\/h2>\n<p align=\"justify\"><span style=\"font-family: Verdana, serif\"><span style=\"font-size: medium\">These were near all the QlikView functions names and categories. If you want to know about any other function, leave your comment in the comment section below and we will provide you with more information.<\/span><\/span><\/p>\n<p align=\"justify\">See Also &#8211; <a href=\"https:\/\/data-flair.training\/blogs\/qlikview-aggregate-function-aggr\/\"><strong>QlikView Aggregate Functions<\/strong><\/a><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/help.qlik.com\/en-US\/qlikview\/November2017\/Subsystems\/Client\/Content\/ChartFunctions\/Functions.htm\">Reference<\/a><\/strong><\/p>\n<p><span hidden class=\"__iawmlf-post-loop-links\" data-iawmlf-links=\"[{&quot;id&quot;:1737,&quot;href&quot;:&quot;https:\\\/\\\/help.qlik.com\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/ChartFunctions\\\/Functions.htm&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251209215111\\\/https:\\\/\\\/help.qlik.com\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/ChartFunctions\\\/Functions.htm&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-17 12:14:55&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-20 13:34:30&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-29 16:00:53&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-05 13:58:24&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-13 02:39:48&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-16 10:45:39&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-28 05:45:40&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-09 08:53:21&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-15 12:43:32&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-23 06:30:10&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-01 02:25:53&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-04 15:07:55&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-15 18:48:31&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-23 15:11:34&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-18 10:11:09&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-21 16:04:15&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-05-07 07:26:08&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-11 13:49:33&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-19 07:27:51&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-05-26 02:27:39&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-31 20:23:40&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-11 10:56:38&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-19 08:46:00&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-23 13:08:03&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-30 02:35:09&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-07-04 05:20:26&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-07-08 20:29:27&quot;,&quot;http_code&quot;:503}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-07-08 20:29:27&quot;,&quot;http_code&quot;:503},&quot;process&quot;:&quot;done&quot;}]\"><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. QlikView Functions &#8211; Objective In our last tutorial, we study QlikView\u00a0Synthetic Keys. Here, we will open a new chapter called QlikView Functions. There are total 21 functions in QlikView. Along with this, we&#46;&#46;&#46;<\/p>\n","protected":false},"author":5,"featured_media":38977,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[17420,17422,17419,17423,17421],"class_list":["post-38928","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-functions-in-qlikview","tag-list-of-functions-in-qlikview","tag-qlikview-functions","tag-types-of-qlikview-functions","tag-what-is-qlikview-function"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>QlikView Functions - Complete List of Functions with Examples - DataFlair<\/title>\n<meta name=\"description\" content=\"QlikView Functions Tutorial- Syntax, Examples:General Numeric, Range, Exponential, Logarithmic, Trigonometric, Hyperbolic, String, Mapping, Inter Record\" \/>\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\/qlikview-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Functions - Complete List of Functions with Examples - DataFlair\" \/>\n<meta property=\"og:description\" content=\"QlikView Functions Tutorial- Syntax, Examples:General Numeric, Range, Exponential, Logarithmic, Trigonometric, Hyperbolic, String, Mapping, Inter Record\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-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-10T06:32:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-13T11:44:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Functions-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1204\" \/>\n\t<meta property=\"og:image:height\" content=\"629\" \/>\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=\"20 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"QlikView Functions - Complete List of Functions with Examples - DataFlair","description":"QlikView Functions Tutorial- Syntax, Examples:General Numeric, Range, Exponential, Logarithmic, Trigonometric, Hyperbolic, String, Mapping, Inter Record","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\/qlikview-functions\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Functions - Complete List of Functions with Examples - DataFlair","og_description":"QlikView Functions Tutorial- Syntax, Examples:General Numeric, Range, Exponential, Logarithmic, Trigonometric, Hyperbolic, String, Mapping, Inter Record","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-functions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-10T06:32:54+00:00","article_modified_time":"2018-11-13T11:44:18+00:00","og_image":[{"width":1204,"height":629,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-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":"20 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlikview-functions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-functions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"QlikView Functions &#8211; Complete List of Functions with Examples","datePublished":"2018-11-10T06:32:54+00:00","dateModified":"2018-11-13T11:44:18+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-functions\/"},"wordCount":3989,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Functions-01.jpg","keywords":["Functions in QlikView","List of Functions in QlikView","QlikView Functions","Types of QlikView Functions","WHat is QlikView Function"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-functions\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-functions\/","name":"QlikView Functions - Complete List of Functions with Examples - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-functions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Functions-01.jpg","datePublished":"2018-11-10T06:32:54+00:00","dateModified":"2018-11-13T11:44:18+00:00","description":"QlikView Functions Tutorial- Syntax, Examples:General Numeric, Range, Exponential, Logarithmic, Trigonometric, Hyperbolic, String, Mapping, Inter Record","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-functions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Functions-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Functions-01.jpg","width":1204,"height":629,"caption":"QlikView Functions - Complete List of Functions with Examples"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-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":"QlikView Functions &#8211; Complete List of Functions with Examples"}]},{"@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\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38928","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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=38928"}],"version-history":[{"count":7,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38928\/revisions"}],"predecessor-version":[{"id":41781,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38928\/revisions\/41781"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/38977"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=38928"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=38928"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=38928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}