Selections in Qlik Sense

Last updated on Sep 21 2022
Debodeep Mukherjee

Table of Contents

Selections in Qlik Sense

Selections and Smart search are the foremost basic yet efficient ways of interacting with data in Qlik Sense. The Selections filter the irrelevant data out and show only the relevant data values by the virtue of associative model. Making selections on specific data values creates a subset of knowledge having the sole those values which link or associates to the chosen value.

Have a glance at Qlik Sense Use Cases

A dedicated visualization in Qlik Sense editor which you employ once you want to filter data through making selections. This visualization is named Filter Pane and is given within the list of charts within the sheet editor.

quick 64 2

Selections in Qlik sense

When you drag it on the editing pane within the center, you’ll need to add dimensions from the loaded tables. the info values from the chosen dimension fields will show within the filter pane on the most sheet. Click on Done to ascertain the filter pane on the sheet.

Let’s revise Qlik Sense Capabilities

quick 65 2

Selections in Qlik sense – Add Dimension from the loaded table

quick 66 2

Filter pane in Selections in Visualizations

Selection States in Qlik Sense

Upon selection, the values take up different colors like green, white, grey etc. Such a colour scheme represents different states of selections like selected, excluded, possible, alternative etc.

Know more about Qlik Sense Filter Pane

COLOR SELECTION STATE
Green Selected
White Possible
Light Grey Alternative
Dark Grey Excluded
Dark Grey (with a tick mark) Selected Excluded

 

There is four basic sort of selection states. we’ve explained each with examples below.

  1. Selected State

The selected state in green with a tick mark, on the values which you click on because the basis for filtering out data and make a subset of relevant or associated data. In our example shown below, we’ve selected the worth ‘Health & Beauty’.

quick 67 2

Selections in Qlik sense – Selected State

  1. Possible State

The possible state represents all possible values associated with the choice we’ve made. The values within the possible state show in white. within the image given below, the possible values for the choice Health & Beauty are burn plant Gel, lotion and pack which is shown in white.

Let’s discuss Qlik Sense Histogram Visualization

quick 68 1

Selections in Qlik sense – Possible State

iii. Alternative State

As you’ll see within the image below, the values of the sector Product_Line expect for one selected value (in green) are light grey in color. This represents the choice state of these values. By alternative state, we mean we’ve other options available to pick . If you deselect the present selection, of these values in light grey become white i.e. the possible state which is, able to select.

quick 69 1

Selections in Visualizations – Alternative states

  1. Excluded State

The values which aren’t associated logically with the chosen value attain the excluded state represented by dark grey color. Such values haven’t any relation with the chosen value (in green) and are deactivated or filtered out.

Have a glance at Qlik Sense Text and Image Visualization

Selections in Visualizations – Excluded State

The values having within the alternate state are excluded once you make a variety within the possible values of the present selection. for instance , our current selection is Health & Beauty and if we select lotion from the three possible values, the alternate states’ values also will get excluded and switch dark grey.

quick 70 1

Selections in Visualizations -Excluded State

Types of Selections in Visualizations

There are several ways during which you’ll make a variety within the visualizations on the sheet.

  1. Click selection in Qlik Sense

Selection is formed once you click on a knowledge value or datum within the visualization. this is often the foremost basic way of choosing values. you’ll deselect the values by again clicking on them.

In the image, the world Nordic is chosen within the chart by clicking. you’ll use this mode of selection in any sort of chart.

selection in Qlik Sense

quick 71 1

  1. Draw selection in Qlik Sense

The draw selection, because the name suggests is formed by manually drawing a line on the info values or data points that you simply want to pick . There are two ways to form a lasso selection, click inside the visualization and either click on the lasso icon or by pressing the Shift key then drawing a line from the cursor on the info values. this may make the choice s and show the selection line drawn by you.

Let’s revise Qlik Sense Box Plot

Draw selections are often made altogether sorts of visualizations apart from Gauge chart, Waterfall chart, KPI and Text & Images.

Examples of draw selections are given below.

In a bar graph .

quick 72

Draw Selection in Bar charts

In a filter pane

quick 73

Draw Selection in Qlik Sense – during a Filter Pane

In a line chart.

quick 74

Draw selection in Line Chart

Do you realize Qlik Sense Treemap Visualization

And, during a scatter plot.

quick 75

Draw selection in Scatter Plot

quick 76

iii. Label Selection in Qlik Selection

We use the label selection to form selections using labels on the chart exes. The image shows a label selection, within the bar graph having grouped or stacked dimensions by selecting anybody of the three label values (2012, 2013, 2014). We select the size like those labels. This selection type is merely applicable in chart visualizations.

quick 77

Label Selection in Qlik Sense

Know more about Qlik Sense Color Function

  1. Lasso Selection in Qlik Sense

The lasso selection is additionally just like the draw selection. Such a variety is formed during a visualization by activating the lasso icon or by pressing the Shift key and making a free-hand revolve around the info points you would like to pick . We use Lasso selection especially in scatter plots or maps where dots or small symbols represent by data values and that we can encircle during a lasso.

Lasso Selection in Qlik Sense

  1. Legend Selection in Qlik Sense

Legend selection is selecting data values (especially in charts) from the legend of that chart. Like within the example shown within the image of a chart , we make selections UK, Nordic and Germany from the legend given below the chart as highlighted by the red box.

Legend Selection in Qlik Sense

quick 78

Let’s take a tour to Qlik Sense Conditional Functions

quick 79 1

  1. Range selection in Qlik Sense

We use Range Selection for choosing a variety of knowledge values on x or y-axis of charts. We make the choice by pressing and holding the proper click of the mouse and dragging the cursor over the range of values you would like to pick . It creates a variety box, blue in color round the set of values selected. The range selection that shows within the images given below.

In this image, we select a variety of 4 values.

 

Range Selection in Qlik Sense

This image selections made on the y-axis of a line chart.

quick 80

Range Selection – y axis

In this example, we select three values as a variety within the high bar graph on its y-axis.

quick 81

Range Selection – high bar Graph

Let’s revise Qlik Sense chart

So, this was beat Selections in Qlik Sense Visualization.

Selections in Qlik Sense

As in QlikView, you’ll make selections on the fields and field values in Qlik Sense also . you’ll make selections through the search field or within the visualizations like charts and filter panes. Whenever a variety is formed during a sheet, then a variety box starts to point out on the choice bar.

In the selection boxes, the state of selections is indicated by green (selected), light gray (alternative) and dark gray (excluded). The values which are locked have a lock indicated ahead of them.

quick 82

Selections in Qlik Sense

Upon clicking on these selection boxes within the selection bar, you get an in depth list of all the values present and during which states they’re present in.

quick 83

list of values in Qlik Sense Selections

As shown within the screenshot, a Selections Menu is given which may be opened from the three dots. Upon opening, this menu gives variety of options for the operations which might be performed on the chosen values.

quick 84

Qlik Sense Selections Operations

The basic options provided serves the aim like,

  • Clear all the selections made.
  • Select all the given values together.
  • Then select only those values which are within the possible state.
  • Select only those values which are within the alternative state.
  • Select only those values which are within the excluded state.

Searching Within Qlik Sense Selections or Visualizations

You can perform an enquiry within the choice boxes from the values it contained. The search option is out there within the selection box, in some visualizations and within the filter pane. Such searches check and return the results only from existing values within the selection box.

quick 85

Searching Within Selections

quick 86

Searched within Qlik Sense Selections

Searching during a selection bar. We searched ‘M’ and selected Melbourne from the list of results.

quick 87

Searching within the Selection bar

Searching during a filter pane.

There are different sorts of text searches which you’ll conduct, such as,

  • Text search, where you’ll look for values by entering text, including wildcard characters, -+ sings.
  • Fuzzy search which is checking out values once you aren’t sure about the spelling. you’ve got to use “~” sign, referred to as the titled character which instructs the system to hold out an inexact search.
  • Numeric search which carries out an enquiry using the relational symbols like “>”, “>=”, “
  • Expression search carries out the look for values which satisfy an expression. you want to initiate this serach by (=) sign.

Editing the Qlik Sense Selections

By editing the selections, this suggests that adding or removing a variety that you simply made. you’ll see all the selections within the selections bar from where you’ll open the sector name within which you would like to edit the selections. To edit the choice , you only need to click on the name of the chosen value to pick or unselect it from the chosen state.

 

Locking and Unlocking Qlik Sense Selections

You can make the selections lock during a particular state using the lock/unlock feature. you’ll lock a group of values during a certain selection state using the lock icon given on the highest of the selections list.

quick 88 1

Locking and Unlocking Qlik Sense Selections

Click on the lock button and you’ll lock the selections.

quick 89

Lock button in Qlik Sense

Selections are locked in order that no changes are often made in them and no selection made in any of the associated sheets affects this selection. you can’t clear or change the state of selections once locked.

You can unlock a locked selection by clicking on the lock icon again. this may make all the chosen values, resume their normal position.

So, this brings us to the end of blog. This Tecklearn ‘Selections in Qlik Sense’ 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.

 

0 responses on "Selections in Qlik Sense"

Leave a Message

Your email address will not be published. Required fields are marked *