

{"id":42629,"date":"2018-11-19T17:00:30","date_gmt":"2018-11-19T11:30:30","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=42629"},"modified":"2018-11-19T17:00:30","modified_gmt":"2018-11-19T11:30:30","slug":"qlik-sense-field-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/","title":{"rendered":"Qlik Sense Field Functions &#8211; Count, Field &amp; Selection Functions"},"content":{"rendered":"<h2><span style=\"font-weight: 400\">1. Objective<\/span><\/h2>\n<p><span style=\"font-weight: 400\">Earlier we discussed <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-day-numbering-functions\/\">Qlik Sense Day Numbering Functions<\/a><\/strong>. Today, we will see Qlik Sense Field Functions. The functions are categorized into two categories, Count functions and field, and selection functions. Let us start with learning and understanding them better.<\/span><\/p>\n<p>So, let&#8217;s start Qlik Sense Field Functions tutorial.<\/p>\n<div id=\"attachment_42647\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Field-Functions-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-42647\" class=\"size-full wp-image-42647\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Field-Functions-01.jpg\" alt=\"Qlik Sense Field Functions - Count, Field and Selection\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Field-Functions-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Field-Functions-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Field-Functions-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Field-Functions-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Field-Functions-01-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Field-Functions-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-42647\" class=\"wp-caption-text\">Qlik Sense Field Functions &#8211; Count, Field and Selection<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-capabilities\/\">Have a look at Qlik Sense Capabilities<\/a><\/strong><\/p>\n<h2>2. Qlik Sense Field Functions<\/h2>\n<p><span style=\"font-weight: 400\">The field functions are applied on the fields of the chart. For every time we load data in Qlik Sense\u2019s memory, an internal table is created. Such tables have data fields(columns) and rows. The field functions help in applying operations on the fields and managing them. These functions can return both integers or string values depending upon what is asked. Also, we know, in all the chart types, we can make selections upon fields and field values. Some of the field functions are used upon these selections as well.<\/span><\/p>\n<h3><span style=\"font-weight: 400\">i. Count functions<\/span><\/h3>\n<h4><span style=\"font-weight: 400\">a. GetSelectedCount() function<\/span><\/h4>\n<p><span style=\"font-weight: 400\">This function returns the count or number of data values which are currently selected i.e. are green. <\/span><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">GetSelectedCount(field_name[,include_excluded[,state_name]])<\/pre>\n<p><span style=\"font-weight: 400\">Where, field_name is the name of the field you want to count the selections in.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Include_excluded parameter if set to True, includes all the excluded fields which got excluded because of the selection made. If you do not mention anything about this parameter in the expression, then it is assumed as False and excluded values are not counted. <\/span><\/p>\n<p><span style=\"font-weight: 400\">State_name is the name of an alternate state that you might set for a specific visualization. If you specify this name in this parameter, then field values will be counted from it. <\/span><\/p>\n<p><span style=\"font-weight: 400\">For example, suppose we have a script in which there are fields named First name, Last name, and Initials.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-null-functions\/\">Do you know about Qlik Sense Null Functions<\/a><\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Names:\r\nLOAD * inline [\r\n\"First name\"|\"Last name\"|\u201dInitials\u201d\r\nRajiv|Mehra|RM\r\nSmriti|Sharma|SS\r\nMohak|Verma|MV\r\nParth|Kashyap|PK\r\nJohn|Desilva|JD\r\nKetan|Bajaj|KB ] (delimiter is '|');<\/pre>\n<p><span style=\"font-weight: 400\">If Rajiv is selected in First name, then the function given below will return, <\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">GetSelectedCount ([First name])<\/pre>\n<p><span style=\"font-weight: 400\">Returns 1 as one value is selected in First name.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Now, given that Rajiv is selected in First name, if we try to count the selected values in the field Initials, then<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">GetSelectedCount ([Initials])<\/pre>\n<p><span style=\"font-weight: 400\">0 will return, as no values are selected in Initials.<\/span><\/p>\n<h4><span style=\"font-weight: 400\">b. GetAlternativeCount() function<\/span><\/h4>\n<p><span style=\"font-weight: 400\">This function returns the number of values selected as alternative values which is shown in light gray.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-mapping-function\/\">Let&#8217;s revise Qlik Sense Mapping Functions<\/a><\/strong><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">GetAlternativeCount(field_name)<\/pre>\n<p><span style=\"font-weight: 400\">Where the field_name is the name of the field in which the values are in the alternative state. <\/span><\/p>\n<p><span style=\"font-weight: 400\">For example, if we make a selection pane from the fields given in the code below, <\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Names:\r\nLOAD * inline [\r\n\"First name\"|\"Last name\"|\u201dInitials\u201d\r\nRajiv|Mehra|RM\r\nSmriti|Sharma|SS\r\nMohak|Verma|MV\r\nParth|Kashyap|PK\r\nJohn|Desilva|JD\r\nKetan|Bajaj|KB ] (delimiter is '|');<\/pre>\n<p><span style=\"font-weight: 400\">Then, if from the First name field, Rajiv is selected the expression,<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">GetAlternativeCount([First name])<\/pre>\n<p><span style=\"font-weight: 400\">Returns, 5 as except for Rajiv, which will be in green, all the other values will be in light gray i.e. in alternative state. <\/span><\/p>\n<h4><span style=\"font-weight: 400\">c. GetPossibleCount() function<\/span><\/h4>\n<p><span style=\"font-weight: 400\">This function returns the count of values under the possible state i.e. those which are shown in white cells. Such values are the possible outcome of a section made in another field. <\/span><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">GetPossibleCount(field_name)<\/pre>\n<p><span style=\"font-weight: 400\">For instance, we have two fields named \u2018<\/span><b>Product Type<\/b><span style=\"font-weight: 400\">\u2019 and \u2018<\/span><b>Item<\/b><span style=\"font-weight: 400\">\u2019. If you select a value \u2018<\/span><b>Health &amp; Beauty<\/b><span style=\"font-weight: 400\">\u2019 from the field <\/span><b>Product Type<\/b><span style=\"font-weight: 400\"> then in the field Item three values will be counted as possible values i.e. the values which Health &amp; Beauty is associated with. The three values are, <\/span><b>Aloe Vera gel, Body lotion, Face pack<\/b><span style=\"font-weight: 400\">. So, the expression, <\/span><span style=\"font-weight: 400\">GetPossibleCount(Item)<\/span><span style=\"font-weight: 400\"> will return 3.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-logical-functions\/\">Have a look at Qlik Sense Logical Functions<\/a><\/strong><\/p>\n<h4><span style=\"font-weight: 400\">d. GetExcludedCount() function<\/span><\/h4>\n<p><span style=\"font-weight: 400\">This function returns the count of excluded values, i.e. such values which are not associated with the current selection. The values in the excluded state are shown in dark gray cells. <\/span><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">GetExcludedCount(field_name)<\/pre>\n<p><span style=\"font-weight: 400\">For instance, in the code given below, <\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Names:\r\nLOAD * inline [\r\n\"First name\"|\"Last name\"|\u201dInitials\u201d\r\nRajiv|Mehra|RM\r\nSmriti|Sharma|SS\r\nMohak|Verma|MV\r\nParth|Kashyap|PK\r\nJohn|Desilva|JD\r\nKetan|Bajaj|KB ] (delimiter is '|');<\/pre>\n<p><span style=\"font-weight: 400\">If <\/span><b>Smriti<\/b><span style=\"font-weight: 400\"> is selected in the <\/span><b>First name<\/b><span style=\"font-weight: 400\"> field then, <\/span><span style=\"font-weight: 400\">GetExcludedCount(Initials)<\/span><span style=\"font-weight: 400\"> will return 5 as there are 5 values which are excluded and only one SS is associated and is in white cell. <\/span><\/p>\n<p><span style=\"font-weight: 400\">And, if <\/span><b>Smriti<\/b><span style=\"font-weight: 400\"> and <\/span><b>John<\/b><span style=\"font-weight: 400\"> both were selected then, <\/span><span style=\"font-weight: 400\">GetExcludedCount(Initials)<\/span><span style=\"font-weight: 400\">will return 3 as the count of excluded values. If no selections are made in the selection panel, then 0 is returned. <\/span><\/p>\n<h4><span style=\"font-weight: 400\">e. GetNotSelectedCount() function<\/span><\/h4>\n<p><span style=\"font-weight: 400\">This function returns the count of not selected values in a field. <\/span><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">GetNotSelectedCount(fieldname[, includeexcluded=false])<\/pre>\n<p><span style=\"font-weight: 400\">Where the <\/span><span style=\"font-weight: 400\">fieldname<\/span><span style=\"font-weight: 400\"> is the name of the field in which you wish to count the number of not selected values.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-pie-chart\/\">Do you know about Qlik Sense Pie Chart<\/a><\/strong><\/p>\n<p><span style=\"font-weight: 400\">Includeexcluded<\/span><span style=\"font-weight: 400\"> parameter if set to False, then the excluded values are not included in the counting. You can set it to True if you wish. <\/span><\/p>\n<p><span style=\"font-weight: 400\">For instance, <\/span><\/p>\n<p><span style=\"font-weight: 400\">GetNotSelectedCount(Country)<\/span><span style=\"font-weight: 400\"> will return the count of not selected values in the field <\/span><b>Country<\/b><span style=\"font-weight: 400\">. <\/span><\/p>\n<h3><span style=\"font-weight: 400\">ii. Field and Selection functions<\/span><\/h3>\n<h4><span style=\"font-weight: 400\">a. GetCurrentSelections() function<\/span><\/h4>\n<p><span style=\"font-weight: 400\">This function returns all the currently selected values in one or more than one field. It returns a string value as a result. <\/span><\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">GetCurrentSelections([record_sep [, tag_sep [, value_sep [, max_values [, state_name]]]]])<\/pre>\n<p><span style=\"font-weight: 400\">Where, <\/span><span style=\"font-weight: 400\">record_sep<\/span><span style=\"font-weight: 400\"> is the separator that is put between fields or records. Usually it is set as &lt;CR&gt;&lt;LF&gt; meaning a new line.<\/span><\/p>\n<p><span style=\"font-weight: 400\">tag_sep<\/span><span style=\"font-weight: 400\"> is the separator put between the field names and the field values. By default, it is set at \u2018:\u2019.<\/span><\/p>\n<p><span style=\"font-weight: 400\">value_sep<\/span><span style=\"font-weight: 400\"> is the separator used between field values. Such as \u2018,\u2019.<\/span><\/p>\n<p><span style=\"font-weight: 400\">max_values<\/span><span style=\"font-weight: 400\"> sets the maximum number of field values that can be listed individually. The default value is set to 6. <\/span><\/p>\n<p><span style=\"font-weight: 400\">From the <\/span><span style=\"font-weight: 400\">state_name<\/span><span style=\"font-weight: 400\"> parameter, you can mention an alternate state of the visualization, if present.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-scatter-plot\/\">Let&#8217;s revise Qlik Sense Scatter Plot<\/a><\/strong><\/p>\n<p><span style=\"font-weight: 400\">For instance, in the code given below,<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Names:\r\nLOAD * inline [\r\n\"First name\"|\"Last name\"|\u201dInitials\u201d\r\nRajiv|Mehra|RM\r\nSmriti|Sharma|SS\r\nMohak|Verma|MV\r\nParth|Kashyap|PK\r\nJohn|Desilva|JD\r\nKetan|Bajaj|KB ] (delimiter is '|');<\/pre>\n<p><span style=\"font-weight: 400\">If <\/span><b>Rajiv<\/b><span style=\"font-weight: 400\"> is selected from the field <\/span><b>First name<\/b><span style=\"font-weight: 400\">, then the expression <\/span><span style=\"font-weight: 400\">GetCurrentSelections()<\/span><span style=\"font-weight: 400\"> will return the string \u2018First name: Rajiv\u2019. <\/span><\/p>\n<p><span style=\"font-weight: 400\">And if, <\/span><b>Rajiv<\/b><span style=\"font-weight: 400\">, <\/span><b>Ketan<\/b><span style=\"font-weight: 400\"> from the field <\/span><b>First name<\/b><span style=\"font-weight: 400\"> and <\/span><b>RM<\/b><span style=\"font-weight: 400\">, <\/span><b>KB<\/b><span style=\"font-weight: 400\"> from the field <\/span><b>Initials<\/b><span style=\"font-weight: 400\">. In this case, the expression <\/span><span style=\"font-weight: 400\">GetCurrentSelections()<\/span><span style=\"font-weight: 400\">will return, <\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">\u2018First name: Rajiv, Ketan\r\nInitials: RM, KB\u2019<\/pre>\n<h4><span style=\"font-weight: 400\">b. GetFieldSelections() function<\/span><\/h4>\n<p><span style=\"font-weight: 400\">The GetFieldSelections() function returns the values that are selected in a particular field. This function returns a string or text value. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Syntax<\/span><span style=\"font-weight: 400\">:<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">GetFieldSelections(field_name [, value_sep [, max_values [, state_name]]])<\/pre>\n<p><span style=\"font-weight: 400\">Where, <\/span><span style=\"font-weight: 400\">field_name <\/span><span style=\"font-weight: 400\">is the name of the field from which you wish to get the selected values. <\/span><\/p>\n<p><span style=\"font-weight: 400\">value_sep<\/span><span style=\"font-weight: 400\"> is the separator used between field values. Such as \u2018,\u2019.<\/span><\/p>\n<p><span style=\"font-weight: 400\">max_values<\/span><span style=\"font-weight: 400\"> sets the maximum number of field values that can be listed individually. The default value is set to 6. <\/span><\/p>\n<p><span style=\"font-weight: 400\">From the <\/span><span style=\"font-weight: 400\">state_name<\/span><span style=\"font-weight: 400\"> parameter, you can mention an alternate state of the visualization, if present.<\/span><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-mathematical-functions\/\">Let&#8217;s take a tour to Qlik Sense Mathematical Functions<\/a><\/strong><\/p>\n<p><span style=\"font-weight: 400\">For instance, if we make a filter pane having the three fields First name, Last name, Initials using the code given below, <\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Names:\r\nLOAD * inline [\r\n\"First name\"|\"Last name\"|\u201dInitials\u201d\r\nRajiv|Mehra|RM\r\nSmriti|Sharma|SS\r\nMohak|Verma|MV\r\nParth|Kashyap|PK\r\nJohn|Desilva|JD\r\nKetan|Bajaj|KB ] (delimiter is '|');<\/pre>\n<p>If three values <b>MV<\/b>, <b>PK<\/b> and <b>KB<\/b> are selected from the field Initials, then the expression GetFieldSelections([Initals]) will return \u2018MV, PK, KB\u2019.<\/p>\n<p>So, this was all in Qlik Sense Field Functions. Hope you like our explanation.<\/p>\n<h2><span style=\"font-weight: 400\">3. Conclusion <\/span><\/h2>\n<p><span style=\"font-weight: 400\">Hence, these were all the important Qlik Sense field functions which are used to handle and count values under different selection states in a field or numerous fields. Still, if you have any questions related to Qlik Sense Field Functions.<\/span><\/p>\n<p><strong>See also &#8211;\u00a0<\/strong><\/p>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/\">Qlik Sense Table Functions<\/a><\/strong><\/p>\n<p><a href=\"https:\/\/www.qlik.com\/us\/products\/qlik-sense\"><strong>Reference for Qlik Sense\u00a0<\/strong><\/a><span hidden class=\"__iawmlf-post-loop-links\" data-iawmlf-links=\"[{&quot;id&quot;:1641,&quot;href&quot;:&quot;https:\\\/\\\/www.qlik.com\\\/us\\\/products\\\/qlik-sense&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20250910054814\\\/https:\\\/\\\/www.qlik.com\\\/us\\\/products\\\/qlik-sense&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-09 14:59:04&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-12 19:36:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-16 00:14:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-19 05:16:53&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-22 07:28:18&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-25 14:15:00&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-29 02:13:23&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-01 05:49:02&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-04 07:22:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-07 08:15:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-11 13:51:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-14 16:21:34&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-19 02:44:56&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-22 03:03:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-25 11:06:55&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-28 12:37:56&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-01 00:15:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-04 05:47:54&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-07 12:47:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-10 15:45:46&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-13 17:01:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-16 17:50:31&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-20 06:42:11&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-23 09:55:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-26 10:25:41&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-01 16:39:38&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-05 05:06:15&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-08 11:22:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-11 13:38:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-14 19:24:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-18 01:36:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-21 23:13:54&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-25 01:59:39&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-29 13:02:13&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-01 13:05:32&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-04 14:23:51&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-07 17:56:15&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-10 21:58:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-14 04:26:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-17 06:08:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-20 07:37:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-23 09:28:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-27 07:37:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-30 08:39:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-04 07:49:58&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-07 09:05:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-10 12:55:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-13 15:31:27&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-17 20:04:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-21 03:24:04&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-25 05:12:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-28 09:09:10&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-01 06:19:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-04 09:38:09&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-07 13:53:53&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-10 23:30:00&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-14 12:40:51&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-17 13:15:26&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-20 15:32:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-23 15:36:41&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-27 02:26:45&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-30 05:49:25&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-07-03 06:52:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-07-06 08:01:28&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-07-09 09:19:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-07-12 20:23:54&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-07-12 20:23:54&quot;,&quot;http_code&quot;:206},&quot;process&quot;:&quot;done&quot;}]\"><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Objective Earlier we discussed Qlik Sense Day Numbering Functions. Today, we will see Qlik Sense Field Functions. The functions are categorized into two categories, Count functions and field, and selection functions. Let us&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":42647,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[17663,17661,17662,17660],"class_list":["post-42629","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-field-and-selection-function-in-qlik-sense","tag-field-functions-in-qlik-sense","tag-qlik-sense-count-function","tag-qlik-sense-field-functions"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Qlik Sense Field Functions - Count, Field &amp; Selection Functions - DataFlair<\/title>\n<meta name=\"description\" content=\"Qlik Sense Field Functions, Count Functions,Selection Functions in Qlik Sense, Syntax, Example of Qlik Sense Field Function\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Field Functions - Count, Field &amp; Selection Functions - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Qlik Sense Field Functions, Count Functions,Selection Functions in Qlik Sense, Syntax, Example of Qlik Sense Field Function\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-19T11:30:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Field-Functions-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=\"7 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qlik Sense Field Functions - Count, Field &amp; Selection Functions - DataFlair","description":"Qlik Sense Field Functions, Count Functions,Selection Functions in Qlik Sense, Syntax, Example of Qlik Sense Field Function","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Field Functions - Count, Field &amp; Selection Functions - DataFlair","og_description":"Qlik Sense Field Functions, Count Functions,Selection Functions in Qlik Sense, Syntax, Example of Qlik Sense Field Function","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-19T11:30:30+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Field-Functions-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Field Functions &#8211; Count, Field &amp; Selection Functions","datePublished":"2018-11-19T11:30:30+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/"},"wordCount":1174,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Field-Functions-01.jpg","keywords":["Field and selection function in Qlik Sense","Field Functions in Qlik Sense","Qlik Sense count function","Qlik Sense Field Functions"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/","name":"Qlik Sense Field Functions - Count, Field &amp; Selection Functions - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Field-Functions-01.jpg","datePublished":"2018-11-19T11:30:30+00:00","description":"Qlik Sense Field Functions, Count Functions,Selection Functions in Qlik Sense, Syntax, Example of Qlik Sense Field Function","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Field-Functions-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Field-Functions-01.jpg","width":1200,"height":628,"caption":"Qlik Sense Field Functions - Count, Field and Selection"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-field-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Qlik Sense Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlik-sense-tutorials\/"},{"@type":"ListItem","position":3,"name":"Qlik Sense Field Functions &#8211; Count, Field &amp; Selection Functions"}]},{"@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\/42629","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=42629"}],"version-history":[{"count":2,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/42629\/revisions"}],"predecessor-version":[{"id":42831,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/42629\/revisions\/42831"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/42647"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=42629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=42629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=42629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}