The field functions are applied on the fields of the chart. for each time we load data in Qlik Sense’s memory, an indoor table is made. Such tables have data fields(columns) and rows. the sector functions help in applying operations on the fields and managing them. These functions can return both integers or string values depending upon what’s asked. Also, we know, altogether the chart types, we will make selections upon fields and field values. a number of the sector functions are used upon these selections also.

Count functions

a. GetSelectedCount() function

This function returns the count or number of knowledge values which are currently selected i.e. are green.
Syntax:
1. GetSelectedCount(field_name[,include_excluded[,state_name]])

Where, field_name is that the name of the sector you would like to count the selections in.
Include_excluded parameter if set to True, includes all the excluded fields which got excluded due to the choice made. If you are doing not mention anything about this parameter within the expression, then it’s assumed as False and excluded values aren’t counted.
State_name is that the name of an alternate state that you simply might set for a selected visualization. If you specify this name during this parameter, then field values are going to be counted from it.
For example, suppose we’ve a script during which there are fields named given name , Last name, and Initials.

Do you realize Qlik Sense Null Functions

1. Names:
2. LOAD * inline [
3. "First name"|"Last name"|”Initials”
4. Rajiv|Mehra|RM
5. Smriti|Sharma|SS
6. Mohak|Verma|MV
7. Parth|Kashyap|PK
8. John|Desilva|JD
9. Ketan|Bajaj|KB ] (delimiter is '|');

If Rajiv is chosen in given name , then the function given below will return,

1. GetSelectedCount ([First name])

Returns 1 together value is chosen in given name .
Now, as long as Rajiv is chosen in given name , if we attempt to count the chosen values within the field Initials, then
1. GetSelectedCount ([Initials])
0 will return, as no values are selected in Initials.

b. GetAlternativeCount() function

This function returns the amount of values selected as alternative values which is shown in light gray.
Let’s revise Qlik Sense Mapping Functions
Syntax:

1. GetAlternativeCount(field_name)

Where the sector _name is that the name of the field during which the values are within the alternative state.
For example, if we make a variety pane from the fields given within the code below,

1. Names:
2. LOAD * inline [
3. "First name"|"Last name"|”Initials”
4. Rajiv|Mehra|RM
5. Smriti|Sharma|SS
6. Mohak|Verma|MV
7. Parth|Kashyap|PK
8. John|Desilva|JD
9. Ketan|Bajaj|KB ] (delimiter is '|');

Then, if from the primary name field, Rajiv is chosen the expression,

1. GetAlternativeCount([First name])

Returns, 5 as apart from Rajiv, which can be in green, all the opposite values are going to be in light gray i.e. in alternative state.

c. GetPossibleCount() function

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 neighborhood made in another field.
Syntax:

1. GetPossibleCount(field_name)

For instance, we’ve two fields named ‘Product Type’ and ‘Item’. If you decide on a worth ‘Health & Beauty’ from the sector Product Type then within the field Item three values are going to be counted as possible values i.e. the values which Health & Beauty is related to . The three values are, burn plant gel, lotion , Face pack. So, the expression, GetPossibleCount(Item) will return 3.

Have a glance at Qlik Sense Logical Functions

d. GetExcludedCount() function
This function returns the count of excluded values, i.e. such values which aren’t related to the present selection. The values within the excluded state are shown in dark gray cells.
Syntax:

If Smriti is chosen within the given name field then, GetExcludedCount(Initials) will return 5 as there are 5 values which are excluded and just one SS is associated and is in leukocyte .
And, if Smriti and John both were selected then, GetExcludedCount(Initials)will return 3 because the count of excluded values. If no selections are made within the selection panel, then 0 is returned.

e. GetNotSelectedCount() function

This function returns the count of not selected values during a field.
Syntax:

1. GetNotSelectedCount(fieldname[, includeexcluded=false])

Where the sector name is that the name of the field during which you would like to count the amount of not selected values.
Do you realize Qlik Sense chart
Includeexcluded parameter if set to False, then the excluded values aren’t included within the counting. you’ll set it to True if you would like .
For instance,
GetNotSelectedCount(Country) will return the count of not selected values within the field Country.

Field and Selection functions

a. GetCurrentSelections() function
This function returns all the currently selected values in one or quite one field. It returns a string value as a result.
Syntax:
1. GetCurrentSelections([record_sep [, tag_sep [, value_sep [, max_values [, state_name]]]]])
Where, record_sep is that the separator that’s put between fields or records. Usually it’s set as meaning a replacement line.
tag_sep is that the separator put between the sector names and therefore the field values. By default, it’s set at ‘:’.
value_sep is that the separator used between field values. like ‘,’.
max_values sets the utmost number of field values which will be listed individually. The default value is about to six .
From the state_name parameter, you’ll mention an alternate state of the visualization, if present.
Let’s revise Qlik Sense Scatter Plot
For instance, within the code given below,

1. Names:
2. LOAD * inline [
3. "First name"|"Last name"|”Initials”
4. Rajiv|Mehra|RM
5. Smriti|Sharma|SS
6. Mohak|Verma|MV
7. Parth|Kashyap|PK
8. John|Desilva|JD
9. Ketan|Bajaj|KB ] (delimiter is '|');

If Rajiv is chosen from the sector given name , then the expression GetCurrentSelections() will return the string ‘First name: Rajiv’.
And if, Rajiv, Ketan from the sector given name and RM, KB from the sector Initials. during this case, the expression GetCurrentSelections()will return,

1. ‘First name: Rajiv, Ketan
2. Initials: RM, KB’
b. GetFieldSelections() function

The GetFieldSelections() function returns the values that are selected during a particular field. This function returns a string or text value.
Syntax:

1. GetFieldSelections(field_name [, value_sep [, max_values [, state_name]]])
Where, field_name is that the name of the sector from which you would like to urge the chosen values.
value_sep is that the separator used between field values. like ‘,’.
max_values sets the utmost number of field values which will be listed individually. The default value is about to six .
From the state_name parameter, you’ll mention an alternate state of the visualization, if present.

For instance, if we make a filter pane having the three fields given name , Last name, Initials using the code given below,

1. Names:
2. LOAD * inline [
3. "First name"|"Last name"|”Initials”
4. Rajiv|Mehra|RM
5. Smriti|Sharma|SS
6. Mohak|Verma|MV
7. Parth|Kashyap|PK
8. John|Desilva|JD
9. Ketan|Bajaj|KB ] (delimiter is '|');

If three values MV, PK and KB are selected from the sector Initials, then the expression GetFieldSelections([Initals]) will return ‘MV, PK, KB’.

So, this brings us to the end of blog. This Tecklearn ‘Qlik Sense Field Functions’ blog helps you with commonly asked questions if you are looking out for a job in Qlik Sense BI. If you wish to learn Qlik Sense and build a career in Business Intelligence domain, then check out our interactive, Qlik Sense Certification Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/qlik-sense-certification-training/

Qlik Sense Certification Training

About the Course

Qlik Sense is a revolutionary Business Analytics tool to come from the Qlik stables. It provides powerful self-service analytics that are readily deployable through interactive and personalized dashboards, data visualization techniques and insightful reports. By the end of this Qlik Sense online training, you will be able to perform key skills of the self-service BI tool – Qlik Sense, such as self-service analytics, write data load scripts, data discovery, create dashboards, develop and share apps, create reports, and design and build data visualizations. All these skills will enable you to clear the Qlik Sense certification exam.

Why should you take Qlik Sense Training?

The average annual pay for a Qlik Sense Professional is $101,871. -Indeed.com.
HSBC, Alstom, Chrysler, Citibank, Accenture and many other MNC’s worldwide use Qlik Sense BI and it has a market share of around 5% globally.
By the end of 2020, the market is expected to touch USD 22.8 billion as modern BI and analytics continue to expand more rapidly, Gartner said in a report.

What you will Learn in this Course?

Introduction and Installation of Qlik Sense

Need for self-service Business Intelligence/Business Analytics
Installation of Qlik Sense and Qlik Sense Desktop

Qlik Sense Features

Qlik Data indexing engine
Data dimensions relationships
Types of Data Loading
Types of Concatenation

Data Modelling

Qlik Sense data architecture
Understanding QVD layer
Converting QlikView files to Qlik Sense files
Incremental Load
Scripting
Create Master Calendar

Advance Data Modelling

Qualify and unqualify
Joins
Keep
Cross Table
Let Vs Set
Calendar Table Creation

Qlik Sense Enterprise

Various Functions
Create QVD Files
Read Data for QVD Files
Create QVD’s
Create Tier 2 Qlik Sense App

Data Visualization

Expressions
Variables
Extensions
Data Visualization

Set Analysis

Set analysis in Qlik Sense
Use set expression like identifiers, operators, modifiers and comparative analysis

Advance Set Analysis

Deploy comparison sets and perform point-in-time analysis

Qlik Sense Storytelling

Storytelling feature of Qlik Sense
Create a story and playback the story

Qlik Sense Visualization

Qlik Sense Charts
Advanced Charts
Creating Dashboards
Real Life Examples

Security

Security aspects of Qlik Sense
Security rules

Got a question for us? Please mention it in the comments section and we will get back to you.

631