Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Arrow up icon
GO TO TOP
Qlik Sense Cookbook

You're reading from   Qlik Sense Cookbook Over 80 recipes on data analytics to solve business intelligence challenges

Arrow left icon
Product type Paperback
Published in Aug 2018
Publisher Packt
ISBN-13 9781788997058
Length 334 pages
Edition 2nd Edition
Arrow right icon
Authors (3):
Arrow left icon
 Labbe Labbe
Author Profile Icon Labbe
Labbe
 Hand Hand
Author Profile Icon Hand
Hand
 Kharpate Kharpate
Author Profile Icon Kharpate
Kharpate
Arrow right icon
View More author details
Toc

Table of Contents (16) Chapters Close

Title Page
Copyright and Credits
Packt Upsell
Contributors
Preface
1. Getting Started with the Data FREE CHAPTER 2. Visualizations 3. Scripting 4. Managing Apps and the User Interface 5. Useful Functions 6. Set Analysis 7. Using Extensions in Qlik Sense 8. Advanced Aggregation with AGGR 9. Tips and Tricks 1. Other Books You May Enjoy Index

Navigating many data points in a scatter chart


The following recipe showcases an interesting concept in the use of scatter charts in Qlik Sense. This feature is available from version 2.0+ of Qlik Sense.

Getting ready

Load the following code into your Qlik Sense application:

Transactions:
Load
 Round(1000*Rand()*Rand()*Rand()) as Sales,
 Round(10*Rand()*Rand()*Rand()) as Quantity,
 RecNo() as TransID
Autogenerate 1000000
 While rand()<0.5 or IterNo()=1;

How to do it…

  1. Create a new sheet and drag a Scatter plot chart object onto the content page.
  2. Add TransID as a dimension.
  3. Add Sum(Sales) as the first measure. Label it Sales.
  4. Add Sum(Quantity) as the second measure. Label it Quantity.
  5. Click on Done.
  6. Name the chart Sales vs Quantity.
  7. You will notice that you cannot select data inside the chart as you can with every other Qlik Sense visualization. To navigate the data, you have to scroll in and out using the mouse wheel. The object will look like the following screenshot try scrolling in:
  1. As you zoom...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime
Visually different images