

{"id":37862,"date":"2018-11-07T15:22:39","date_gmt":"2018-11-07T09:52:39","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=37862"},"modified":"2021-12-07T11:23:46","modified_gmt":"2021-12-07T05:53:46","slug":"qlikview-operators","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-operators\/","title":{"rendered":"QlikView Operators &#8211; 5 Major Types of Operators in QlikView"},"content":{"rendered":"<p>In our last tutorial, we discussed\u00a0<a href=\"https:\/\/data-flair.training\/blogs\/qlikview-backus-naur-form-bnf\/\"><strong>QlikView Backus Naur Form<\/strong><\/a>. Today, we will learn what are QlikView Operators. Moreover, we will learn types of operators in QlikView:\u00a0QlikView String Operators, Relational Operators, Numeric Operators, Logical Operators, Bit Operators, Binary Operators, and Unary Operators in QlikView with syntax and examples.<\/p>\n<p>So, let&#8217;s start QlikView Operators Tutorial.<\/p>\n<div id=\"attachment_37874\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Binary-Operator-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-37874\" class=\"size-full wp-image-37874\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Binary-Operator-01.jpg\" alt=\"QlikView Operators - 5 Major Types of Operators in QlikView\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Binary-Operator-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Binary-Operator-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Binary-Operator-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Binary-Operator-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Binary-Operator-01-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Binary-Operator-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-37874\" class=\"wp-caption-text\">QlikView Operators &#8211; 5 Major Types of Operators in QlikView<\/p><\/div>\n<h3>QlikView Operators<\/h3>\n<p>The word<strong> Operator<\/strong> must be a familiar one to you if you are well acquainted with the terms used in the word of computer science. While learning the basics of any computer language, you learn terms like data types, variables, operators etc.<\/p>\n<p>So, it is evident that understanding the operators is as important as learning anything else in a language like C, SQL, C++ etc. QlikView Operators are symbols or keywords which are used to apply mathematical operations on data values.<\/p>\n<p><strong>QlikView Operator<\/strong> is a symbol or a keyword which is used to perform an action on the data values it is used on. It is through reading the operators that the compiler of a computer understands what mathematical or logical function is to be applied to the values given during code execution. The data values on which the operator works and gives results are known as Operands or Arguments in QlikView.<\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-management-service-qms\/\">Do you know What is\u00a0QMC and QMS API?<\/a><\/strong><\/p>\n<p>For instance, if in a computer language we wish to multiply two digits (data items or data values), then the operator with the symbol, * (asterisk) will be used. In the expression 2*4, the Operator is \u2018*\u2019 and the Operands are the values 2 and 4. Depending on the number of Operands there are two types of QlikView Operators (also applicable in QlikView),<\/p>\n<h4>i. Unary Operators in QlikView<\/h4>\n<p>The Unary Operators works only on one Operand. The format in which a unary operator typically appears is operator operand. Like -1, where &#8211; is the unary minus operator and 1 is the operand.<\/p>\n<p>There are several unary operators like,<\/p>\n<ul>\n<li>Increment and Decrement operators having symbols (++) and (&#8211;) respectively.<\/li>\n<li>Single\/Unary Plus and Minus operators having symbols (+) and (-) respectively.<\/li>\n<li>Not or negation operator with a symbol \u2018!\u2019 is also a unary operator.<\/li>\n<\/ul>\n<h4>ii. Binary Operators in QlikView<\/h4>\n<p>The Binary Operator operates or works on two operands. The format is, operand1 operator operand2. Most of the QlikView operators used are binary type operators. Like the binary plus operator used for adding two numbers, 5+2, where + is the binary operator and 5 and 2 are the two operands.<\/p>\n<h3>Types of Operators in QlikView<\/h3>\n<p>Here, we will discuss five major types of QlikView Operators:<\/p>\n<div id=\"attachment_37875\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Types-of-Operators-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-37875\" class=\"size-full wp-image-37875\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Types-of-Operators-01.jpg\" alt=\"Types of QlikView Operators\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Types-of-Operators-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Types-of-Operators-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Types-of-Operators-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Types-of-Operators-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Types-of-Operators-01-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-Types-of-Operators-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-37875\" class=\"wp-caption-text\">Types of QlikView Operators<\/p><\/div>\n<h4>i. Bit Operators in QlikView<\/h4>\n<p>As the name suggests, the bit or bitwise operators convert the normal data values or operands to a 32-bit integer form and perform operations and return results in the same form. The operand value is processed bit by bit and if an operand is not in the signed integer form then the bit operators return NULL.<\/p>\n<p>There are six-bit operators, bitnot, bitand, bitor, bitxor,&gt;&gt;, &lt;&lt;. Given below are all the bit operators explained with an example.<\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-master-calendar\/\">Have a look &#8211; How to Create QlikView Master Calendar?<\/a><\/strong><\/p>\n<ul>\n<li>\n<p align=\"justify\"><strong><span style=\"color: #000000\"><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\">bitnot<\/span><\/span><\/span><\/strong><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Bit inverse) \u2013<\/strong> It is a unary operator and returns the logical inverse of the operand performed bit by bit.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"justify\"><strong><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Example: <\/span><\/span><\/span><\/strong><span style=\"color: #000000\"><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\">bitnot 17<\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> returns -18<\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><strong><span style=\"color: #000000\"><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\">bitand<\/span><\/span><\/span><\/strong><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Bit and)-<\/strong> Returns the logical AND of the operands performed bit by bit.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"justify\"><strong><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Example: <\/span><\/span><\/span><\/strong><span style=\"color: #000000\"><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\">17 bitand 7<\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> returns 1<\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><strong><span style=\"color: #000000\"><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\">bitor<\/span><\/span><\/span><\/strong><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Bit or) &#8211;<\/strong> Returns the logical OR.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong>Example:<\/strong> <\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\">17 bitor 7<\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> returns 23<\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><strong><span style=\"color: #000000\"><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\">bitxor<\/span><\/span><\/span><\/strong><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Bit exclusive or) &#8211;<\/strong> Returns the logical exclusive or of the operands performed bit by bit.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"justify\"><strong><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Example:<\/span><\/span><\/span><\/strong><span style=\"color: #000000\"><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\">17 bitxor 7<\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> returns 22<\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><strong><span style=\"color: #000000\"><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\">&gt;&gt;<\/span><\/span><\/span><\/strong><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Bit right shift) &#8211;<\/strong> Returns the first operand shifted to the right. Example: <\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\">8 &gt;&gt; 2<\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> returns 2<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<ul>\n<li>\n<p align=\"justify\"><strong><span style=\"color: #000000\"><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\">&lt;&lt;<\/span><\/span><\/span><\/strong><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Bit left shift) &#8211;<\/strong> Returns the fir<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<h4>ii. Logical Operators\u00a0in QlikView<\/h4>\n<p>The logical operators in QlikView are similar to the logical operators in other computer languages like C, C++. An operand value is interpreted logically and the results are presented as True (-1) or False (0). The logical operators used in QlikView are keywords like not, and, or, xor. They are explained in the table below.<\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>not<\/b><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Logical inverse) &#8211;<\/strong> Returns the logical inverse of the operand.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>and<\/b><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Logical and) &#8211;<\/strong> Returns the logical and of the operands.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>or<\/b><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Logical or) &#8211;<\/strong> Returns the logical or of the operands.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<ul>\n<li>\n<p align=\"justify\"><strong><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">XOr<\/span><\/span><\/span><\/strong><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Logical exclusive or) &#8211;<\/strong> Returns the logical exclusive-or of the operands. i.e. like logical or. The results is False if both operands evaluate True. <\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<h4>iii. Numeric Operators\u00a0in QlikView<\/h4>\n<p>The numeric operators are the most commonly and widely used mathematical symbols like + &#8211; * \/ etc. These QlikView operators take up numerical values as it is, perform mathematical operations on them according to the operator and return a numeric value.<\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>+<\/b><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> Arithmetic addition returns the sum of the two operands.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>&#8211; <\/b><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> Arithmetic subtraction returns the operand multiplied by -1. and the binary the difference between the two operands.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>*<\/b><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> Arithmetic multiplication returns the product of the two operands.<\/span><\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>\/<\/b><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> Arithmetic division returns the ratio between the two operands.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/\">Follow this link to know about\u00a0QlikView Star Schema<\/a><\/strong><\/p>\n<h4>iv. Relational Operators\u00a0in QlikView<\/h4>\n<p>The relational operators, as the name suggests, analyses the relation between two operands and based on the result returns the value in True (-1) or False (0). There are two unique relational operators apart from the usual ones like greater than &gt; , less than &lt; etc. These are,<\/p>\n<h5>a. Precedes<\/h5>\n<p>The precedes operator returns True if the value on the left has less value in terms of string comparison than the value on the right. For example, if we put the precedes operator between two digits in string form,<\/p>\n<p>\u2018 2\u2019 precedes \u2018 4\u2019 returns TRUE<\/p>\n<p>i.e. the string value of number 2 is less than or comes before 4 and so TRUE is returned.<\/p>\n<p>If a number in the string form is compared with \u2018 \u2018 empty space then the expression would be,<\/p>\n<p>\u20181 \u2019 precedes \u2018 2\u2019 returns FALSE<\/p>\n<p>This is because the value on left (1) is not less than or comes before<\/p>\n<p>(\u2018 \u2018) empty space present in front of the number 2.<\/p>\n<p>But with the normal relational Less than &lt; operator only the numerical values and not strings are compared with each other,<\/p>\n<p>\u2018 3\u2019 &lt; \u2018 4\u2019 returns TRUE<\/p>\n<p>Or<\/p>\n<p>\u20183 \u2019 &lt; \u2018 4\u2019 returns TRUE<\/p>\n<p>Space does not make a difference here.<\/p>\n<h5>b. Follows<\/h5>\n<p>With similar manner as that of \u2018precedes\u2019 operator, \u2018follows\u2019 operator returns True if the value (textually interpreted) on the left is followed by or is greater in value than the value on the right. Otherwise, False is returned. For instance,<\/p>\n<p>\u2018 6\u2019 follows \u2018 5\u2019 returns TRUE<\/p>\n<p>While,<\/p>\n<p>\u20186 \u2019 follows \u2018 5\u2019 returns FALSE<\/p>\n<p>This is so because of the same empty space being considered and having a value in when interpreted as texts or strings. And the ASCII value of empty space (\u2018 \u2019) is less than that of numbers.<\/p>\n<p>\u2018 6\u2019 &gt; \u2018 5\u2019 returns TRUE<\/p>\n<p>\u20186 \u2019 &gt; \u2018 5\u2019 returns FALSE<\/p>\n<p>This is because the relational operator &gt; interprets values numerically and only compares the values 6 and 5 without considering the ASCII value of the space.<\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qvd-files\/\">Do you know How to Create QlikView Data Files (QVD)?<\/a><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Given below are the generally used relational operators in QlikView.<\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>&lt;<\/b><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Less than) &#8211;<\/strong> Returns the logical value of the evaluation of the comparison. Example 7 &lt; 8 returns True.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>&lt;=<\/b><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Less than or equal) &#8211;<\/strong> Returns the logical value of the evaluation of the comparison. For example, if you assign a condition 10 &lt;= 20, then the result will be True because 10 is less than 20 and 20 &lt;= 20 will also return True.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>&gt;<\/b><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Greater than) &#8211;<\/strong> Returns the logical value of the evaluation of the comparison. Example, 10 &gt; 5 returns True.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>&gt;=<\/b><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Greater than or equal) &#8211;<\/strong> Returns the logical value of the evaluation of the comparison. Example 10 &gt;= 5 returns True but 10 &gt;= 12 returns False.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>=<\/b><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Equals) &#8211;<\/strong> Returns the logical value of the evaluation of the comparison. 10 = 10 returns True.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>&lt;&gt;<\/b><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (Not equivalent to) &#8211;<\/strong> Returns the logical value of the evaluation of the comparison. It is used to assign a variable a value which it will not equate it to. <\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<h4>v. String Operators\u00a0in QlikView<\/h4>\n<p>The string operators &amp; and like perform operations on the string values only. There are two main string operators which we are going to discuss. One is the \u2018&amp;\u2019 operator which is the operator for string concatenation. It takes up two string operands and joins the two giving one combine string as a result.<\/p>\n<p>The other string operator is the like operator which matches the two string operands on the right and left and returns the answer as a Boolean expression of TRUE or FALSE depending on whether the values on two sides are matching or not.<\/p>\n<p>These QlikView operators are explained in further detail with an example below.<\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>&amp;<\/b><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><strong> (String concatenation) \u2013<\/strong> This operation returns a text string, that consists of the two operand strings, one after another.<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"justify\"><strong><span style=\"color: #000000\"> <span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Example:\u00a0<\/span><\/span><\/span><\/strong><\/p>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">abc&#8217; &amp; &#8216;xyz&#8217; returns &#8216;abcxyz&#8217;<\/span><\/span><\/span><\/p>\n<ul>\n<li><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>like<\/b><\/span><\/span><\/span><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> \u2013 It is a string comparison with wildcard characters which returns a boolean True (-1) if the string before the operator is matched by the string after the operator. The second string may contain the wildcard characters like * or ?. <\/span><\/span><\/span><\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Example:<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"color: #000000\"> <span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">abc&#8217; like &#8216;a*&#8217; returns True (-1)<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"color: #000000\"> <span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">abcd&#8217; like &#8216;a?c&#8221;&#8221; returns True (-1)<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"color: #000000\"> <span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">abc&#8217; like &#8216;a??bc&#8217; returns False (0)<\/span><\/span><\/span><\/p>\n<p>So, this was all about QlikView Operators. Hope you like our explanation.<\/p>\n<h3>Conclusion<\/h3>\n<p>We have discussed all the five types of QlikView operators used in scriptwriting namely, Bit, Logical, Relational, Numeric and String operators in QlikView. Each operator type comprises either of symbols or keywords and has a certain function to do.<\/p>\n<p>We hope this explanation was helpful in strengthening your understanding of the topic QlikView Operators. In case of any doubts and queries, drop your comments in the comment box below.<\/p>\n<p>Related Topic &#8211;\u00a0<strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-navigation\/\">QlikView Navigation Pane<\/a><\/strong><\/p>\n<p><strong><a href=\"https:\/\/help.qlik.com\/en-US\/qlikview\/November2017\/Subsystems\/Client\/Content\/Scripting\/Operators\/operators.htm\">Reference<\/a><\/strong><span hidden class=\"__iawmlf-post-loop-links\" data-iawmlf-links=\"[{&quot;id&quot;:1751,&quot;href&quot;:&quot;https:\\\/\\\/help.qlik.com\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/Scripting\\\/Operators\\\/operators.htm&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251209220612\\\/https:\\\/\\\/help.qlik.com\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/Scripting\\\/Operators\\\/operators.htm&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-11 21:49:19&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-22 17:19:16&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-03 18:57:38&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-08 19:54:37&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-13 01:57:57&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-26 03:53:01&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-02 20:11:26&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-13 13:39:35&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-25 12:05:23&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-18 09:27:00&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-22 22:01:51&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-27 12:54:33&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-18 06:05:15&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-29 13:47:33&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-07-04 06:48:47&quot;,&quot;http_code&quot;:200}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-07-04 06:48:47&quot;,&quot;http_code&quot;:200},&quot;process&quot;:&quot;done&quot;}]\"><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In our last tutorial, we discussed\u00a0QlikView Backus Naur Form. Today, we will learn what are QlikView Operators. Moreover, we will learn types of operators in QlikView:\u00a0QlikView String Operators, Relational Operators, Numeric Operators, Logical Operators,&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":37874,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[17094,17101,17100,17099,17098,17095,17097,17096,17102,17093],"class_list":["post-37862","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-operators-in-qlikview","tag-qlikview-binary-operators","tag-qlikview-bit-operators","tag-qlikview-logical-operators","tag-qlikview-numeric-operators","tag-qlikview-operators","tag-qlikview-relational-operators","tag-qlikview-string-operators","tag-qlikview-unary-operators","tag-types-of-operators-in-qlikview"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>QlikView Operators - 5 Major Types of Operators in QlikView - DataFlair<\/title>\n<meta name=\"description\" content=\"What are QlikView Operators- Types of Operators in QlikView, String, Relational, Numeric, Logical, Bit, Binary, Unary Operators in QlikView with examples\" \/>\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-operators\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Operators - 5 Major Types of Operators in QlikView - DataFlair\" \/>\n<meta property=\"og:description\" content=\"What are QlikView Operators- Types of Operators in QlikView, String, Relational, Numeric, Logical, Bit, Binary, Unary Operators in QlikView with examples\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-operators\/\" \/>\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-07T09:52:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:53:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Binary-Operator-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"QlikView Operators - 5 Major Types of Operators in QlikView - DataFlair","description":"What are QlikView Operators- Types of Operators in QlikView, String, Relational, Numeric, Logical, Bit, Binary, Unary Operators in QlikView with examples","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-operators\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Operators - 5 Major Types of Operators in QlikView - DataFlair","og_description":"What are QlikView Operators- Types of Operators in QlikView, String, Relational, Numeric, Logical, Bit, Binary, Unary Operators in QlikView with examples","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-operators\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-07T09:52:39+00:00","article_modified_time":"2021-12-07T05:53:46+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Binary-Operator-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":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlikview-operators\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-operators\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"QlikView Operators &#8211; 5 Major Types of Operators in QlikView","datePublished":"2018-11-07T09:52:39+00:00","dateModified":"2021-12-07T05:53:46+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-operators\/"},"wordCount":1623,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-operators\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Binary-Operator-01.jpg","keywords":["Operators in QlikView","QlikView Binary Operators","QlikView Bit Operators","QlikView Logical Operators","QlikView Numeric Operators","QlikView OPerators","QlikView Relational Operators","QlikView String Operators","QlikView Unary Operators","Types of Operators in QlikView"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-operators\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-operators\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-operators\/","name":"QlikView Operators - 5 Major Types of Operators in QlikView - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-operators\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-operators\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Binary-Operator-01.jpg","datePublished":"2018-11-07T09:52:39+00:00","dateModified":"2021-12-07T05:53:46+00:00","description":"What are QlikView Operators- Types of Operators in QlikView, String, Relational, Numeric, Logical, Bit, Binary, Unary Operators in QlikView with examples","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-operators\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-operators\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-operators\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Binary-Operator-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Binary-Operator-01.jpg","width":1200,"height":628,"caption":"QlikView Operators - 5 Major Types of Operators in QlikView"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-operators\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"QlikView Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlikview\/"},{"@type":"ListItem","position":3,"name":"QlikView Operators &#8211; 5 Major Types of Operators in QlikView"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/37862","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=37862"}],"version-history":[{"count":8,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/37862\/revisions"}],"predecessor-version":[{"id":105005,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/37862\/revisions\/105005"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/37874"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=37862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=37862"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=37862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}