In a scatter plot or chart of Qlik Sense, we represent such instances as dots or bubbles which contains two or three measure values for them. for instance, sales and quantity of distinct products displayed by one dot or bubble. So, once you make a scatter plot in Qlik Sense, we select two measure fields for every x-axis and y-axis against one dimension field. If you add a 3rd measure of an equivalent dimension, its values will reflect within the size of the bubble.

quick 118

Scatter Plot in Qlik Sense

In the scatter plot shown within the image above, the 2 measures selected are ‘Sales’ and ‘Quantity’ and therefore the dimension whose values are going to be plotted as bubbles against the 2 measure values is ‘Customer’. The third measure which is represented by the dimensions of the bubble is ‘Cost’ i.e. more the value , greater the dimensions of the bubble. you’ll use color coding to ascertain the density of knowledge points when an outsized data set is employed during a scatter plot. This helps in visualizing the dense areas or hot spots within the plot which potentially gives useful and important insights to the analyst.

Have a glance at Qlik Sense Treemap Visualizations

Advantages and Limitations of Qlik Sense Scatter Plot

Pros of Scatter Plot

Scatter plots are significant in visualizing data as they show the contribution of various factors within the performance or status of a component which is being analyzed. Suppose, we’ve a scatter plot as a visualization for sales analysis. Now, we’ve taken product category or different product types because the dimension which can be plotted within the graph using two values, total sales done, and total units sold for every category of product.

So, just watching the position of the bubble made on the scatter plot, you’ll analyze the recognition of a product, because the parameters indicating popularity are what proportion units of it were sold and for a way much (total). Thus, scatter plots are very useful once you want to seek out out the correlation or relation between two or three measure values like one dimension. It easily contains, manages and displays large data sets which are to be analyzed.

Cons of Scatter Plot

However, what has begin as a drawback of using scatter plot is that it’d often appear difficult to know for inexperienced users. this is often possible due to scatter plot follows a special concept of creation, i.e. the 2 measures are on x-axis and y-axis and therefore the dimension values are represented as bubbles. It gets more complex when a 3rd measure is added which is shown because the sizes of bubbles. So, the chart should be made in such how that it must contain many informative bits thereon in order that users, no matter their technical capabilities, can understand the chart.

You must learn Qlik Sense chart

Creating a Qlik Sense Scatter Plot

Follow the steps given below to make a scatter chart in Qlik Sense.

Open the editor within the sheet you would like to make the scatter plot in. The editor is opened by edit icon.
Select a Scatter plot from the list of visualizations available within the Charts section of the Assets panel. Drag the scatter plot on the editing grid.

Select Scatter Plot

First, add the dimension field from Add dimension option. Then add the primary measure by Add measure option and choose an aggregation type for it. Next, add the second measure and choose an aggregation for it.

Let’s revise Qlik Sense Gauge Chart

quick 120

Add Dimension in Scatter Plot

quick 121

Add Measures in Scatter Plot

Make other necessary changes from the properties tab if you would like to and click on on Done icon to end editing and consider the ultimate scatter plot on the sheet.

Final Scatter Plot on Sheet

Do you realize Qlik Sense Box Plot

Properties Panel of Qlik Sense

The properties panel of a lively scatter plot within the editor provides many options for managing the properties of the scatter plot. There are several sections within the properties panel from where you’ll select and set different aspects of scatter plot accordingly.

Data

From this section, you’ll add new dimensions and measures and manage the old ones. Basically, you’ll give labels to the measures which can be displayed on the scatter plot, also, you’ll edit expressions of the measures if you would like to vary the sort of aggregation that’s applied on the measures.

quick 123

Data in Scatter Plot

Add-ons

From the Add-ons sections, you’ll add references of other data sets, or visualizations both for x-axis and y-axis. So, put conditions which control the airing of the visualization.

Let’s revise Qlik Sense Text and Image Visualization

quick 124

Add-ons in Scatter Plot

iii. Appearance

The appearance section is to manage all the looks specific elements of a scatter plot. allow us to discuss some sub-sections of the looks section and what we will do with the choices .

General

The first is that the General section from where you’ll add titles, subtitles, and footnotes which are informative texts explaining the scatter plot.

quick 125

Add Titles, Subtitles in Scatter Plot

Have a glance at Qlik sense Histogram Visualization

Presentation

Below it’s the Presentation section which has the Navigation option, used for panning and zooming closer into the scatter plot. you’ll set the bubble size from the dimensions bar given below the navigation option. Also, you’ll set the labels and grid line spacing.

quick 126 1

Set the labels and grid line spacing

Color and Legends

Next is that the Appearance section, from where you’ll set the coloring criterion of the bubbles on the scatter plot. So, you’ll select coloring from four options, i.e. single color, color by dimension, color by expression and color by measure.

If you decide on the only color option, you’ll select the colour from the colour options and therefore the bubbles of the scatter plot are going to be displayed therein color, as shown within the screenshots attached below.

You must read Qlik Sense Filter Pane

quick 126

Select colors in Scatter Plot

quick 127

Bubbles in Scatter Plot

If you decide on the colour by dimension option, then each dimension value will have a definite color because no two dimensions will an equivalent . you’ll select the colours from reminder 12 colors or 100 colors. It depends upon the amount of dimensions your dataset contains. Here, you furthermore may get the choice of show/hide legend which are descriptive texts showing which color corresponds to what dimension value.

quick 128

Selecting Colors in Qlik Sense Scatter Plot

quick 129

Qlik Sense Scatter Plot Color Selection

And, if you decide on the colour by measure option then you get gradient color options to settle on from. you’ll also select from the 2 or three measures you’ve got added within the plot. within the resultant scatter plot, the colour grading shows in legend or reference bar given along side it. As you’ll see within the image of scatter chart given below, the colour shades are changing as we move from rupees 2000 to rupees 25,000. and therefore the colors of the dots or bubbles also change like that moving from left to all along the x-axis.

quick 130

Select Color by Measure Option

quick 131

Select Color From two or three Measures

X-axis: (Measure1)

In this section, the properties of the measure field selected because the x-axis measure are often manipulated. you modify the label and title settings that’s what to point out and what to not show, set the position of the axis i.e. bottom or top and adjust the scaling as wide, medium and narrow.

Let’s find out how to put in Qlik Sense

quick 132

The x-axis in Scatter Plot

Y-axis: (Measure2)

The second measure, which is shown on the y-axis are often managed from here. during this section too, you’ll set the label, title options, axis position and scaling on the y-axis.

quick 133

Y-axis in Qlik Sense Scatter Plot

So, this brings us to the end of blog. This Tecklearn ‘Using a Scatter Plot 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.

772