{"id":38068,"date":"2018-11-09T14:50:07","date_gmt":"2018-11-09T09:20:07","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=38068"},"modified":"2021-12-07T11:23:43","modified_gmt":"2021-12-07T05:53:43","slug":"qlikview-search","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-search\/","title":{"rendered":"QlikView Search &#8211; 8 Types of Search Options in QlikView"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:1748,&quot;href&quot;:&quot;https:\\\/\\\/help.qlik.com\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/Text_search_and_numeric_search.htm&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20190627215438\\\/http:\\\/\\\/help.qlik.com:80\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/Text_search_and_numeric_search.htm&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-09 21:55:30&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-29 11:14:56&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-08 19:49:31&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-14 15:29:03&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-19 12:00:48&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-23 08:42:17&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-01 21:02:26&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-06 09:33:09&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-11 10:44:25&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-19 14:02:30&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-22 20:42:43&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-27 13:52:17&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-05 00:43:15&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-11 07:55:47&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-19 16:27:29&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-30 10:56:35&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-03 13:01:53&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-08 18:54:04&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-14 12:47:46&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-22 10:26:41&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-21 06:49:09&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-28 14:37:58&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-02 18:32:22&quot;,&quot;http_code&quot;:503}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-02 18:32:22&quot;,&quot;http_code&quot;:503},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<p>In our last chapter, we talked about <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-security\/\">QlikView Security<\/a><\/strong>. Today, we will discuss a new chapter <strong>Qlikview Search<\/strong>. Along with this, we will learn different types of Searches in QlikView:\u00a0 Normal Search, Wildcard Search, Fuzzy Search, Numeric Search, Expression Search, Compound Search, Associative Search, and Advanced Search in QlikView.<\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Searching for specific fields or field values in data tables having tens of thousands of data values is for sure a tedious and daunting task. Thus, QlikView search comes in very handy for users dealing with huge amounts of data.\u00a0<\/span><\/span><\/span><\/p>\n<p align=\"justify\">So, let&#8217;s start QlikView Search Tutorial.<\/p>\n<h3 align=\"justify\">QlikView Search<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">QlikView has a very efficient search engine. Although, one way of finding required data values is through selecting desired values manually in the table. For instance, if in a sales document, you only want sales information of USA, then you will have to click on the data field where the USA is written. This will take up the USA as the selected value and will display only the values related to and associated with the USA, deactivating all the other irrelevant values. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">A separate search object is available in QlikView through which you can filter through the vast ocean of information and get information so that you get to deal with only the values of your interest. Searching for values using the Search object is a lot faster than making selections manually. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The mode of searching through a search object is via writing a text search or string. Also, the search string can be typed in any case (upper or lower or mixed) and is not case sensitive. The search can use either by creating a separate search sheet object. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">To create a Search Object, either go to add new sheet object from the Layout tab or right-click anywhere on the sheet and select <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>New Sheet Object&gt;Search Object\u2026<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">. A search object will appear where you can type your search string. In the settings window, you can select what data fields and tables you want to be available and search data from.<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-sheet-object\/\">Do you know What is\u00a0QlikView Sheet and Object?<\/a><\/strong><\/p>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Another way to invoke searching in QlikView is through the List Box sheet object. <strong>Create a list box<\/strong> by going to <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>Layout&gt;New Sheet Object&gt;List Box<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">. Select the data field from the loaded table whose values you want to be displayed in the List box. Once you are done with creating the list box as desired and it gets displayed, you will have a search bar on the top of the list box. <\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">You can search for relevant and present values through that search bar. If after searching for desired values, you make a selection in the list box, all the other active sheet objects (table box, charts etc.) will filter their information leaving only the relevant data values on display (associative property). <\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The search can also ripple through multiple active list boxes present on the same sheet and in that case all these list boxes will respond to the search string typed in one list box amongst them.<\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Search in a list box.<\/span><\/span><\/span><\/p>\n<h3 align=\"justify\">Types of Search in QlikView<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Data can search in several different ways depending upon the purpose of search and type of data values being searched. The difference between types of search originates from the way a string is interpreted. Let us explore the seven types of QlikView search.<\/span><\/span><\/span><\/p>\n<div id=\"attachment_38095\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Types-of-Searches-in-QlikView-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38095\" class=\"size-full wp-image-38095\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Types-of-Searches-in-QlikView-01.jpg\" alt=\"QlikView Search - 8 Types of Search Options in QlikView\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Types-of-Searches-in-QlikView-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Types-of-Searches-in-QlikView-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Types-of-Searches-in-QlikView-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Types-of-Searches-in-QlikView-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Types-of-Searches-in-QlikView-01-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Types-of-Searches-in-QlikView-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-38095\" class=\"wp-caption-text\">QlikView Search &#8211; 8 Types of Search Options in QlikView<\/p><\/div>\n<h4 align=\"justify\">i. QlikView Normal Search<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">A Normal Text Search in QlikView takes up simple (no wildcards) text strings and looks for its match in the field values by searching just the beginning of every word in the values. The first image shows how a normal search responds.<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-web-server-qvws\/\">Follow this link to know about QlikView Web Server (QVWS)<\/a><\/strong><\/p>\n<div id=\"attachment_38079\" style=\"width: 184px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38079\" class=\"size-full wp-image-38079\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search3.png\" alt=\"QlikView Search - QlikView Normal Search\" width=\"174\" height=\"234\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search3.png 174w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search3-112x150.png 112w\" sizes=\"auto, (max-width: 174px) 100vw, 174px\" \/><\/a><p id=\"caption-attachment-38079\" class=\"wp-caption-text\">QlikView Normal Search<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The second image shows that if there is more than one string entered in the search bar and each string is separated by an empty space. Then each string will evaluate separately and return results accordingly. The empty spaces interpreted as the logical operator OR. <\/span><\/span><\/span><\/p>\n<div id=\"attachment_38080\" style=\"width: 530px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search4.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38080\" class=\"size-full wp-image-38080\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search4.png\" alt=\"QlikView Search - QlikView Normal Search\" width=\"520\" height=\"225\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search4.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search4-150x65.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search4-300x130.png 300w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/a><p id=\"caption-attachment-38080\" class=\"wp-caption-text\">QlikView Search &#8211; QlikView Normal Search<\/p><\/div>\n<h4 align=\"justify\">ii. QlikView Wildcard Search<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The wildcard search in QlikView is an extended version of the normal search and is also a type of text search. The only difference between a normal and wildcard search is the way their strings are evaluated or interpreted. The wildcard search includes the use of several wildcards like:<\/span><\/span><\/span><\/p>\n<h5 align=\"justify\">a. *<\/h5>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">This wildcard is used with letters or characters to find a perfect match in the field values. There are three ways in which this wildcard can be used. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">First is before a letter <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>*a<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> this will give all the values that have words starting with the letter A or a.<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">A second way is after a letter, <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>a*<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> which returns all the values ending with the letter A or a.<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">And the third way is before and after a letter, <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>*a*<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> which returns the values with words containing the letter a. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Also, the use of space must be done attentively while searching using wildcards. Because let\u2019s say you search \u2018*<\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><i>paper\u2019<\/i><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> , it may return the values ending with \u2018paper\u2019 like <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><i>Newspaper<\/i><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> and just the word <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><i>Paper<\/i><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> as well (if it resides in the data field). But if you put a space and make it * <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><i>paper <\/i><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">then the search will be only those values that end with \u2018paper\u2019.<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-installation\/\">Have a look at &#8211;\u00a0How to Download &amp; Install QlikView<\/a><\/strong><\/p>\n<h5 align=\"justify\">b. ?<\/h5>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">This wildcard is used when the user is not sure about the spelling of the word he is looking for. In place of the letters the user is unsure about, \u2018?\u2019 a wildcard is used. For instance, if you search <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>b?ck<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">, it will return all the values like a buck, back, beck, bick etc. Also, the search string can be less precise like <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>H?? T???e<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> and the search will return the values with three letter words starting with H and a five-letter word staring with T and ending on e.\u00a0<\/span><\/span><\/span><\/p>\n<h5 align=\"justify\">c. ^<\/h5>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Much like in the normal search, this wildcard searches the words starting with the searched letters using ^ wildcard. Like, ^Ra will return the values having words starting with Ra. This is different from the normal search as it is used in programming search like in a Set Analysis expression<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">There are certain interesting facts about the wildcard search. It is a strict, precise and case-sensitive match where the value entered in the string search is matched accurately with the field value. Unlike the normal search, space is not considered as a logical OR in a wildcard search. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">A string having wildcards will only return values that accurately match the string hence no space or alternative search results emerge. For example, if you search \u2018*newspaper\u2019, only the value ending with the word newspaper will be displayed and not the values containing the word newspaper like \u2018This newspaper is yesterday\u2019s\u2019 as it does not end with newspaper. <\/span><\/span><\/span><\/p>\n<div id=\"attachment_38081\" style=\"width: 533px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search5.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38081\" class=\"wp-image-38081 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search5.png\" alt=\"QlikView Search - QlikView Wildcard Search\" width=\"523\" height=\"234\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search5.png 523w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search5-150x67.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search5-300x134.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search5-520x233.png 520w\" sizes=\"auto, (max-width: 523px) 100vw, 523px\" \/><\/a><p id=\"caption-attachment-38081\" class=\"wp-caption-text\">QlikView Search &#8211; QlikView Wildcard Search<\/p><\/div>\n<h4 align=\"justify\">iii. QlikView Fuzzy Search<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Fuzzy search is used in the case of a misspelling of a word or when the user is unsure about the way a value is written exactly. When you make a fuzzy search using a tilde-character (~) before the search string, the result will be arranged according to the degree of resemblance of the field values to the search string you have typed. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The search result list goes from most resembling values to the least resembling values. If after getting the search results you press Enter, then the search automatically selects the first value from the list.<\/span><\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-scripting\/\">Do you know What are the features of QlikView Script Editor?<\/a><\/strong><\/p>\n<div id=\"attachment_38082\" style=\"width: 190px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search6.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38082\" class=\"size-full wp-image-38082\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search6.png\" alt=\"QlikView Search - QlikView Fuzzy Search\" width=\"180\" height=\"234\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search6.png 180w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search6-115x150.png 115w\" sizes=\"auto, (max-width: 180px) 100vw, 180px\" \/><\/a><p id=\"caption-attachment-38082\" class=\"wp-caption-text\">QlikView Fuzzy Search<\/p><\/div>\n<h4 align=\"justify\">iv. Qlikview Numeric Search<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The numeric search is a numeric variant of a text search. The difference is that it is used for searching field values containing numbers. The numeric search must start with one of the four relational operators,<\/span><\/span><\/span><\/p>\n<h5>a.\u00a0<span style=\"font-family: Arial, serif\"><span style=\"font-size: large\"><span lang=\"en-US\">&gt; <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: large\"><span lang=\"en-US\">(Greater than)<\/span><\/span><\/span><\/h5>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">For example, &gt;10,000 will give all the values that are greater than 10,000.<\/span><\/span><\/span><\/p>\n<h5>b.\u00a0<span style=\"font-family: Arial, serif\"><span style=\"font-size: large\"><span lang=\"en-US\">&gt;= <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: large\"><span lang=\"en-US\">(Greater than or equal to)<\/span><\/span><\/span><\/h5>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">For example, &gt;=10,000 will give the values greater than 10,000 but will also give 10,000 if present in the dataset.<\/span><\/span><\/span><\/p>\n<h5 align=\"justify\">c.\u00a0<span style=\"font-family: Arial, serif\"><span style=\"font-size: large\"><span lang=\"en-US\">&lt; <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: large\"><span lang=\"en-US\">(Less than)<\/span><\/span><\/span><\/h5>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">For example, &lt;10,000 will return all the values less than 10,000.<\/span><\/span><\/span><\/p>\n<h5 align=\"justify\">d.\u00a0<span style=\"font-family: Arial, serif\"><span style=\"font-size: large\"><span lang=\"en-US\">&lt;= <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: large\"><span lang=\"en-US\">(Less than or equal to)<\/span><\/span><\/span><\/h5>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">For example, &lt;=10,000 will return the values less than 10,000 as well as 10,000 (if present). <\/span><\/span><\/span><\/p>\n<div id=\"attachment_38083\" style=\"width: 337px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search7.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38083\" class=\"wp-image-38083 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search7.png\" alt=\"QlikView Search - QlikView Numeric Search\" width=\"327\" height=\"234\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search7.png 327w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search7-150x107.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search7-300x215.png 300w\" sizes=\"auto, (max-width: 327px) 100vw, 327px\" \/><\/a><p id=\"caption-attachment-38083\" class=\"wp-caption-text\">QlikView Search &#8211; QlikView Numeric Search<\/p><\/div>\n<h4 align=\"justify\">v. Qlikview Expression Search<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The expression search, as the name suggests, takes up expression strings as input, evaluated that expression and returns search results matching the evaluation results. Every expression search begins with an equal to sign \u2018=\u2019. To search by an expression, it is recommended to type the string in aggregate function expression type. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">This ensures proper results. In the images given below, the expression search is used to find certain values greater than or less than the mentioned values from the sum happening on field values individually. <\/span><\/span><\/span><\/p>\n<div id=\"attachment_38086\" style=\"width: 209px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search8.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38086\" class=\"size-full wp-image-38086\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search8.png\" alt=\"QlikView Search - QlikView Expression Search\" width=\"199\" height=\"234\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search8.png 199w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search8-128x150.png 128w\" sizes=\"auto, (max-width: 199px) 100vw, 199px\" \/><\/a><p id=\"caption-attachment-38086\" class=\"wp-caption-text\">QlikView Expression Search<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qvd-files\/\">Also, Refer &#8211; How to Create QlikView Data Files (QVD)?\u00a0<\/a><\/strong><\/p>\n<h4>vi. QlikView Compound Search<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The compound search is used to carry out logically complex searches. The search expressions use several wildcards and logical operators like \u2018&amp;\u2019 and \u2018|\u2019. The complex expressions used in compound search can be stored in Actions or Bookmarks. <\/span><\/span><\/span><\/p>\n<div id=\"attachment_38087\" style=\"width: 360px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search10.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38087\" class=\"size-full wp-image-38087\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search10.png\" alt=\"QlikView Search - QlikView Compound Search\" width=\"350\" height=\"225\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search10.png 350w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search10-150x96.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search10-300x193.png 300w\" sizes=\"auto, (max-width: 350px) 100vw, 350px\" \/><\/a><p id=\"caption-attachment-38087\" class=\"wp-caption-text\">QlikView Search &#8211; QlikView Compound Search<\/p><\/div>\n<h4 align=\"justify\">vii.\u00a0QlikView Associative Search<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The associate search is a search mode in the list box. It is an indirect search where the search string entered for the field values present in the list box also shows the match results with the values of other fields. Let us understand with the example of the image given below.<\/span><\/span><\/span><\/p>\n<div id=\"attachment_38088\" style=\"width: 405px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search11.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38088\" class=\"wp-image-38088 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search11.png\" alt=\"QlikView Search - QlikView Associative Search\" width=\"395\" height=\"265\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search11.png 395w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search11-150x101.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search11-300x201.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search11-272x182.png 272w\" sizes=\"auto, (max-width: 395px) 100vw, 395px\" \/><\/a><p id=\"caption-attachment-38088\" class=\"wp-caption-text\">QlikView Search &#8211; QlikView Associative Search<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Here the list box is made for the field \u2018Product_name\u2019. When we type a search string \u2018b\u2019 all the values in the field Product_name having words starting with the letter B comes as a result. Now to see the associative search results click on the chevron \u2018&gt;&gt;\u2019 given at the right of the search bar. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">You will find a second list of search results which are the values matching the search string criterion but are from another field of the table called \u2018Product_Type\u2019. This type of indirect searching is called associative search.<\/span><\/span><\/span><\/p>\n<h4 align=\"justify\">viii. QlikView Advanced Search<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The advanced search is used in case of searching through complex strings. The advanced search is invoked by pressing Ctrl+Shift+F. Once the search dialogue box opens you can enter advanced and complex queries in there. If you start the search string with \u2018=\u2019 then you will be able to enter advanced search expressions. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The expressions follow the logic of Boolean functions where if the values contained in a field matches the search criterion the expression returns True for matched values and False for the unmatched. The matched values are then displayed as the search result. <\/span><\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">An example of an advanced search is,<\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" align=\"justify\"><strong><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">=StoreLocation <\/span><\/span><\/span><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">like<\/span><\/span><\/span><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> \u2018I*\u2019 or StoreLocation <\/span><\/span><\/span><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">like<\/span><\/span><\/span><span style=\"font-family: Courier New, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> \u2018*A\u2019<\/span><\/span><\/span><\/strong><\/p>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">This search will return all the values having words that either start from the letter I or end with the letter A, contained in the field StoreLocation. <\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The advanced search dialogue box is different from the normal text search box. The search expression entered in advanced search only executes after the user clicks on the <\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"><b>Go<\/b><\/span><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\"> button. <\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">There are several other options available to the user in the advanced search box.<\/span><\/span><\/span><\/p>\n<h5 align=\"justify\">a. Search in<\/h5>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The Search in bar has all the active fields available which can also changes by the user from the drop-down list. The search expression will be applied only on the values of the field selected here.<\/span><\/span><\/span><\/p>\n<h5 align=\"justify\">b. Search Expression<span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">\u00a0<\/span><\/span><\/span><\/h5>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">This is the space where the search string or expression is typed.<\/span><\/span><\/span><\/p>\n<h5 align=\"justify\">c. Go<\/h5>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">By clicking the Go button, the search string entered is applied or implemented on the field values of the field selected and search results are displayed.<\/span><\/span><\/span><\/p>\n<h5 align=\"justify\">d. Back<\/h5>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">With the Back option, you can go to the last selection that you made. The last 100 selections made by you are stored in QlikView\u2019s memory.<\/span><\/span><\/span><\/p>\n<h5 align=\"justify\">e. Forward<\/h5>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">It goes to the selection next to the current selection made. It is of use when to went back several selections using the Back button. To come back to the previous selections, the Forward button is used.<\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-bar-chart\/\">Follow this link to know about &#8211; QlikView Bar, Pie Chart &amp;\u00a0TextBox<\/a><\/strong><\/p>\n<h5>f. Clear Field<\/h5>\n<p lang=\"en-US\" align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">It clears the current field selection.<\/span><\/span><\/span><\/p>\n<h5>g. Clear All<\/h5>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">This clears all the active selections of the document.<\/span><\/span><\/span><\/p>\n<h5 align=\"justify\">h. Help<\/h5>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">It opens the advanced search Help dialog box.<\/span><\/span><\/span><\/p>\n<h5>i. Close<\/h5>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">Closes the dialog completely.<\/span><\/span><\/span><\/p>\n<div id=\"attachment_38098\" style=\"width: 1075px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search12-1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38098\" class=\"size-full wp-image-38098\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search12-1.png\" alt=\"QlikView Search - QlikView Advanced Search\" width=\"1065\" height=\"663\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search12-1.png 1065w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search12-1-150x93.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search12-1-300x187.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search12-1-768x478.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search12-1-1024x637.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/search12-1-520x324.png 520w\" sizes=\"auto, (max-width: 1065px) 100vw, 1065px\" \/><\/a><p id=\"caption-attachment-38098\" class=\"wp-caption-text\">QlikView Search &#8211; QlikView Advanced Search<\/p><\/div>\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">The tabs present at the bottom half window of the advanced search dialog box, you can select and paste syntax of QlikView Field expressions, Functions and Variables. You can edit the copied syntax as you please in the Search Expression window.<\/span><\/span><\/span><\/span><\/p>\n<p align=\"justify\">So, this was all about\u00a0QlikView Search. Hope you like our explanation.<\/p>\n<h3 align=\"justify\">Conclusion<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><span lang=\"en-US\">This was a complete account of the\u00a0QlikView Search option are available.\u00a0QlikView Search is a very useful tool with great flexibility in terms of ways in which the user can carry out the search task. We hope this tutorial provided a comprehensive account of the topic with helpful examples. Share your feedback with us!<\/span><\/span><\/span><\/p>\n<p align=\"justify\">Related topic &#8211; <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-dashboard\/\">QlikView Dashboard <\/a><\/strong><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/help.qlik.com\/en-US\/qlikview\/November2017\/Subsystems\/Client\/Content\/Text_search_and_numeric_search.htm\">Reference<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In our last chapter, we talked about QlikView Security. Today, we will discuss a new chapter Qlikview Search. Along with this, we will learn different types of Searches in QlikView:\u00a0 Normal Search, Wildcard Search,&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":38096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[17138,17136,17132,17134,17139,17133,17135,17137],"class_list":["post-38068","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-qlikview-advanced-search-example","tag-qlikview-advanced-search-multiple-values","tag-qlikview-advanced-search-syntax","tag-qlikview-find-string-in-text","tag-qlikview-search-string-multiple-values","tag-search-box-in-qlikview","tag-wildcard-search-in-qlikview","tag-wildmatch-qlikview"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>QlikView Search - 8 Types of Search Options in QlikView - DataFlair<\/title>\n<meta name=\"description\" content=\"QlikView Search Option - Types of Seaches in QlikView: Normal, QlikView Wildcard, Fuzzy Search, Numeric, Expression, Compound, Associative, Advanced Search\" \/>\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-search\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Search - 8 Types of Search Options in QlikView - DataFlair\" \/>\n<meta property=\"og:description\" content=\"QlikView Search Option - Types of Seaches in QlikView: Normal, QlikView Wildcard, Fuzzy Search, Numeric, Expression, Compound, Associative, Advanced Search\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-search\/\" \/>\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-09T09:20:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:53:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Search-in-QlikView-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=\"12 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"QlikView Search - 8 Types of Search Options in QlikView - DataFlair","description":"QlikView Search Option - Types of Seaches in QlikView: Normal, QlikView Wildcard, Fuzzy Search, Numeric, Expression, Compound, Associative, Advanced Search","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-search\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Search - 8 Types of Search Options in QlikView - DataFlair","og_description":"QlikView Search Option - Types of Seaches in QlikView: Normal, QlikView Wildcard, Fuzzy Search, Numeric, Expression, Compound, Associative, Advanced Search","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-search\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-09T09:20:07+00:00","article_modified_time":"2021-12-07T05:53:43+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Search-in-QlikView-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":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlikview-search\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-search\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"QlikView Search &#8211; 8 Types of Search Options in QlikView","datePublished":"2018-11-09T09:20:07+00:00","dateModified":"2021-12-07T05:53:43+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-search\/"},"wordCount":2287,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-search\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Search-in-QlikView-01.jpg","keywords":["qlikview advanced search example","qlikview advanced search multiple values","qlikview advanced search syntax","qlikview find string in text","qlikview search string multiple values","search box in qlikview","wildcard search in qlikview","wildmatch qlikview"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-search\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-search\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-search\/","name":"QlikView Search - 8 Types of Search Options in QlikView - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-search\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-search\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Search-in-QlikView-01.jpg","datePublished":"2018-11-09T09:20:07+00:00","dateModified":"2021-12-07T05:53:43+00:00","description":"QlikView Search Option - Types of Seaches in QlikView: Normal, QlikView Wildcard, Fuzzy Search, Numeric, Expression, Compound, Associative, Advanced Search","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-search\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-search\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-search\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Search-in-QlikView-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Search-in-QlikView-01.jpg","width":1200,"height":628,"caption":"QlikView Search - 8 Types of Search Options in QlikView"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-search\/#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 Search &#8211; 8 Types of Search Options 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\/38068","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=38068"}],"version-history":[{"count":11,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38068\/revisions"}],"predecessor-version":[{"id":105001,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38068\/revisions\/105001"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/38096"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=38068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=38068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=38068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}