Home Page Icon
Home Page
Table of Contents for
Table of Contents
Close
Table of Contents
by Neeraj Kharpate, Philip Hand
Qlik Sense® Cookbook
Qlik Sense® Cookbook
Table of Contents
Qlik Sense® Cookbook
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers, and more
Why subscribe?
Free access for Packt account holders
Instant updates on new Packt books
Preface
What this book covers
What you need for this book
Who this book is for
Sections
Getting ready
How to do it…
How it works…
There’s more…
See also
Conventions
Reader feedback
Customer support
Downloading the example code
Downloading the color images of this book
Errata
Piracy
Questions
1. Getting Started with the Data
Introduction
Extracting data from databases and data files
Getting ready…
How to do it…
How it works…
There's more…
See also…
Extracting data from Web Files
Getting ready…
How to do it…
How it works…
There's more…
See also…
Activating the Legacy Mode in Qlik Sense® desktop
Getting ready…
How to do it…
How it works…
There's more…
See also…
Extracting data from custom databases
Getting ready…
How to do it…
How it works…
There's more…
See also…
Invoking help while in the data load editor or the expression editor
Getting ready…
How to do it…
There's more…
See also…
Previewing data in the Data model viewer
Getting ready
How to do it…
How it works...
Viewing the data model
Viewing the associations
Table Meta Data
There's more...
Creating a Master Library from the Data model viewer
Getting ready
How to do it...
How it works...
There's more…
Using a Master Library in the Edit mode
Getting ready
How to do it...
There's more…
2. Visualizations
Introduction
Creating Snapshots
Getting ready
How to do it…
How it works…
There's more…
See also
Creating and adding content to a story
Getting ready
How to do it…
How it works…
There's more…
See also
Adding embedded sheets to the story
Getting ready
How to do it…
How it works…
There's more…
Highlighting the performance measure in a bar chart
Getting ready
How to do it…
How it works…
There's more…
See also
Associating persistent colors to field values
Getting ready
How to do it…
How it works…
There's more…
See also
Using the ColorMix1 function
Getting ready
How to do it…
How it works…
There's more…
See also
Composition
Getting ready
How to do it…
How it works…
There's more…
Relationships
Getting ready
How to do it…
How it works…
Comparison
Getting ready
How to do it…
How it works…
See also
Distribution
Getting ready
How to do it…
How it works…
Structuring visualizations
Getting ready
How to do it…
How it works…
3. Scripting
Introduction
Structuring the script
Getting ready
How to do it…
How it works…
Efficiently debugging the script
Getting ready
How to do it…
How it works…
There's more…
See also
Packaging the code in script files
Getting ready
How to do it…
How it works…
See also
How to use sub routines in Qlik Sense®
Getting ready
How to do it…
How it works…
There's more…
See also
Optimizing the UI calculation speed
Getting ready
How to do it…
How it works…
Optimizing the reload time of the application
Getting ready
How to do it…
How it works…
Using a For Each loop to load data from multiple files
Getting ready
How to do it…
How it works…
There's more…
Using the Concat function to store multiple field values in a single cell
Getting ready
How to do it…
How it works…
There's more…
See also
4. Managing Apps and User Interface
Introduction
Publishing a Qlik Sense® application created in Qlik Sense® desktop
Getting ready
How to do it…
How it works…
There's more…
Creating private, approved, and community sheets
Getting ready
How to do it…
How it works…
There's more…
See also
Publishing a Qlik Sense® application to Qlik Sense® cloud
Getting ready
How to do it…
How it works…
There's more…
Creating geo maps in Qlik Sense®
Getting ready
How to do it…
How it works…
There's more…
Reference lines in Sales versus Target gauge chart
Getting ready
How to do it…
How it works…
There's more…
See also
Effectively using the KPI object in Qlik Sense®
Getting ready
How to do it…
How it works…
There's more…
See also
Creating Tree Maps
Getting ready
How to do it…
How it works…
There's more…
Creating dimensionless bar charts in Qlik Sense®
Getting ready
How to do it…
How it works…
There's more…
See also
Adding Reference Lines to trendline charts
Getting ready
How to do it…
How it works…
Creating text and images
Getting ready
How to do it…
Adding Images
Adding Text
How it works…
Applying limitations to charts
Getting ready
How to do it…
How it works…
There's more…
Adding thumbnails – a clear environment
Getting ready
How to do it…
How it works…
Navigating many data points in a scatter chart
Getting ready
How to do it…
How it works…
There's more…
5. Useful Functions
Introduction
Using an extended interval match to handle Slowly Changing Dimensions
Getting ready
How to do it…
How it works…
There's more…
See also
Using the Previous() function to identify the latest record for a dimensional value
Getting ready
How to do it…
How it works…
There's more…
See also
Using the NetworkDays() function to calculate the working days in a calendar month
Getting ready
How to do it…
How it works…
See also
Using the Concat() function to display a string of field values as a dimension
Getting ready
How to do it…
How it works…
There's more…
See also
Using the Minstring() function to calculate the age of the oldest case in a queue
Getting ready
How to do it…
How it works…
There's more…
See also
Using the Rangesum() function to plot cumulative figures in trendline charts
Getting ready
How to do it…
How it works…
See also
Using the Fractile() function to generate quartiles
Getting ready
How to do it…
How it works…
There's more…
See also
Using the FirstSortedValue() function to identify the median in a quartile range
Getting ready
How to do it…
How it works…
There's more…
See also
Using the Declare and Derive functions to generate Calendar fields
Getting ready
How to do it…
How it works…
There's more…
See also
Setting up a moving annual total figure
Getting ready
How to do it…
How it works…
There's more…
See also
Using the For Each loop to extract files from a folder
Getting ready
How to do it…
How it works…
Using the Peek() function to create a currency Exchange Rate Calendar
Getting ready
How to do it…
How it works…
There's more…
See also
Using the Peek() function to create a Trial Balance sheet
Getting ready
How to do it…
How it works…
See also
6. Set Analysis
Introduction
Cracking the syntax for Set Analysis
Getting ready
How to do it…
How it works…
There's more…
See also
Using flags in Set Analysis
Getting ready
How to do it…
How it Works…
There's more…
See also
Using the = sign with variables in Set Analysis
Getting ready
How to do it…
How it works…
See also
Point in time using Set Analysis
Getting ready
How to do it…
How it works…
Using comparison sets in Set Analysis
Getting ready
How to do it…
How it works…
Using embedded functions in Set Analysis
Getting ready
How to do it…
How it works…
There's more…
Creating a multi-measure expression in Set Analysis
Getting ready
How to do it…
How it works…
Using search strings inside a set modifier
Getting ready
How to do it…
How it works…
There's more…
See also
Capturing a list of field values using a concat() function in Set Analysis
Getting ready
How to do it…
How it works…
Using the element functions P() and E() in Set Analysis
Getting ready
How to do it…
How it works…
There's more…
See also
7. Extensions in Qlik Sense®
Introduction
Creating an HTML visualization extension for Qlik Sense®
Getting ready
How to do it…
How it works…
There's more…
See also
Defining a Properties panel in Qlik Sense® visualizations
Getting ready
How to do it…
How it works…
There's more…
Creating custom components within Qlik Sense® visualizations
Getting ready
How to do it…
How it works…
There's more…
Using data with extensions
Getting ready
How to do it…
How it works…
See also
8. What's New in Version 2.1.1?
Introduction
Using the visual exploration capability in Qlik Sense® 2.1.1
Getting ready
How to do it…
How it works…
There's more…
See also
Defining variables in Qlik Sense®
Getting ready
How to do it…
How it works…
There's more…
See also
Exporting stories to MS PowerPoint
Getting ready
How to do it…
How it works…
There's more…
See also
Using the Qlik Dev Hub in Qlik Sense® 2.1.1
Getting ready
How to do it…
Single configurator
Extensions editor
Mashup editor
How it works…
There's more…
Single configurator
Extension editor
See also
Using Extension editor in Qlik Dev Hub
Getting ready
How to do it…
How it works…
There's more…
See also
Using Qlik Dev Hub to generate mashups
Getting ready
How to do it…
How it works…
There's more…
See also
Embedding Qlik Sense® application on a website using a single configurator
Getting ready
How to do it…
How it works…
There's more…
See also
Using the Qlik DataMarket
Getting ready…
How to do it…
How it works…
See also
Creating dynamic charts in Qlik Sense®
Getting ready
How to do it…
How it works…
There's More….
Using Smart Search
Getting ready
How to do it…
How it works…
There's More….
See also
Using smart data load profiling
Getting ready
How to do it…
How it works…
There's More….
Conclusion
A. Appendix
Keyboard shortcuts in Qlik Sense® Desktop
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Cover
Next
Next Chapter
Qlik Sense® Cookbook
Table of Contents
Qlik Sense® Cookbook
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers, and more
Why subscribe?
Free access for Packt account holders
Instant updates on new Packt books
Preface
What this book covers
What you need for this book
Who this book is for
Sections
Getting ready
How to do it…
How it works…
There’s more…
See also
Conventions
Reader feedback
Customer support
Downloading the example code
Downloading the color images of this book
Errata
Piracy
Questions
1. Getting Started with the Data
Introduction
Extracting data from databases and data files
Getting ready…
How to do it…
How it works…
There's more…
See also…
Extracting data from Web Files
Getting ready…
How to do it…
How it works…
There's more…
See also…
Activating the Legacy Mode in Qlik Sense® desktop
Getting ready…
How to do it…
How it works…
There's more…
See also…
Extracting data from custom databases
Getting ready…
How to do it…
How it works…
There's more…
See also…
Invoking help while in the data load editor or the expression editor
Getting ready…
How to do it…
There's more…
See also…
Previewing data in the Data model viewer
Getting ready
How to do it…
How it works...
Viewing the data model
Viewing the associations
Table Meta Data
There's more...
Creating a Master Library from the Data model viewer
Getting ready
How to do it...
How it works...
There's more…
Using a Master Library in the Edit mode
Getting ready
How to do it...
There's more…
2. Visualizations
Introduction
Creating Snapshots
Getting ready
How to do it…
How it works…
There's more…
See also
Creating and adding content to a story
Getting ready
How to do it…
How it works…
There's more…
See also
Adding embedded sheets to the story
Getting ready
How to do it…
How it works…
There's more…
Highlighting the performance measure in a bar chart
Getting ready
How to do it…
How it works…
There's more…
See also
Associating persistent colors to field values
Getting ready
How to do it…
How it works…
There's more…
See also
Using the ColorMix1 function
Getting ready
How to do it…
How it works…
There's more…
See also
Composition
Getting ready
How to do it…
How it works…
There's more…
Relationships
Getting ready
How to do it…
How it works…
Comparison
Getting ready
How to do it…
How it works…
See also
Distribution
Getting ready
How to do it…
How it works…
Structuring visualizations
Getting ready
How to do it…
How it works…
3. Scripting
Introduction
Structuring the script
Getting ready
How to do it…
How it works…
Efficiently debugging the script
Getting ready
How to do it…
How it works…
There's more…
See also
Packaging the code in script files
Getting ready
How to do it…
How it works…
See also
How to use sub routines in Qlik Sense®
Getting ready
How to do it…
How it works…
There's more…
See also
Optimizing the UI calculation speed
Getting ready
How to do it…
How it works…
Optimizing the reload time of the application
Getting ready
How to do it…
How it works…
Using a For Each loop to load data from multiple files
Getting ready
How to do it…
How it works…
There's more…
Using the Concat function to store multiple field values in a single cell
Getting ready
How to do it…
How it works…
There's more…
See also
4. Managing Apps and User Interface
Introduction
Publishing a Qlik Sense® application created in Qlik Sense® desktop
Getting ready
How to do it…
How it works…
There's more…
Creating private, approved, and community sheets
Getting ready
How to do it…
How it works…
There's more…
See also
Publishing a Qlik Sense® application to Qlik Sense® cloud
Getting ready
How to do it…
How it works…
There's more…
Creating geo maps in Qlik Sense®
Getting ready
How to do it…
How it works…
There's more…
Reference lines in Sales versus Target gauge chart
Getting ready
How to do it…
How it works…
There's more…
See also
Effectively using the KPI object in Qlik Sense®
Getting ready
How to do it…
How it works…
There's more…
See also
Creating Tree Maps
Getting ready
How to do it…
How it works…
There's more…
Creating dimensionless bar charts in Qlik Sense®
Getting ready
How to do it…
How it works…
There's more…
See also
Adding Reference Lines to trendline charts
Getting ready
How to do it…
How it works…
Creating text and images
Getting ready
How to do it…
Adding Images
Adding Text
How it works…
Applying limitations to charts
Getting ready
How to do it…
How it works…
There's more…
Adding thumbnails – a clear environment
Getting ready
How to do it…
How it works…
Navigating many data points in a scatter chart
Getting ready
How to do it…
How it works…
There's more…
5. Useful Functions
Introduction
Using an extended interval match to handle Slowly Changing Dimensions
Getting ready
How to do it…
How it works…
There's more…
See also
Using the Previous() function to identify the latest record for a dimensional value
Getting ready
How to do it…
How it works…
There's more…
See also
Using the NetworkDays() function to calculate the working days in a calendar month
Getting ready
How to do it…
How it works…
See also
Using the Concat() function to display a string of field values as a dimension
Getting ready
How to do it…
How it works…
There's more…
See also
Using the Minstring() function to calculate the age of the oldest case in a queue
Getting ready
How to do it…
How it works…
There's more…
See also
Using the Rangesum() function to plot cumulative figures in trendline charts
Getting ready
How to do it…
How it works…
See also
Using the Fractile() function to generate quartiles
Getting ready
How to do it…
How it works…
There's more…
See also
Using the FirstSortedValue() function to identify the median in a quartile range
Getting ready
How to do it…
How it works…
There's more…
See also
Using the Declare and Derive functions to generate Calendar fields
Getting ready
How to do it…
How it works…
There's more…
See also
Setting up a moving annual total figure
Getting ready
How to do it…
How it works…
There's more…
See also
Using the For Each loop to extract files from a folder
Getting ready
How to do it…
How it works…
Using the Peek() function to create a currency Exchange Rate Calendar
Getting ready
How to do it…
How it works…
There's more…
See also
Using the Peek() function to create a Trial Balance sheet
Getting ready
How to do it…
How it works…
See also
6. Set Analysis
Introduction
Cracking the syntax for Set Analysis
Getting ready
How to do it…
How it works…
There's more…
See also
Using flags in Set Analysis
Getting ready
How to do it…
How it Works…
There's more…
See also
Using the = sign with variables in Set Analysis
Getting ready
How to do it…
How it works…
See also
Point in time using Set Analysis
Getting ready
How to do it…
How it works…
Using comparison sets in Set Analysis
Getting ready
How to do it…
How it works…
Using embedded functions in Set Analysis
Getting ready
How to do it…
How it works…
There's more…
Creating a multi-measure expression in Set Analysis
Getting ready
How to do it…
How it works…
Using search strings inside a set modifier
Getting ready
How to do it…
How it works…
There's more…
See also
Capturing a list of field values using a concat() function in Set Analysis
Getting ready
How to do it…
How it works…
Using the element functions P() and E() in Set Analysis
Getting ready
How to do it…
How it works…
There's more…
See also
7. Extensions in Qlik Sense®
Introduction
Creating an HTML visualization extension for Qlik Sense®
Getting ready
How to do it…
How it works…
There's more…
See also
Defining a Properties panel in Qlik Sense® visualizations
Getting ready
How to do it…
How it works…
There's more…
Creating custom components within Qlik Sense® visualizations
Getting ready
How to do it…
How it works…
There's more…
Using data with extensions
Getting ready
How to do it…
How it works…
See also
8. What's New in Version 2.1.1?
Introduction
Using the visual exploration capability in Qlik Sense® 2.1.1
Getting ready
How to do it…
How it works…
There's more…
See also
Defining variables in Qlik Sense®
Getting ready
How to do it…
How it works…
There's more…
See also
Exporting stories to MS PowerPoint
Getting ready
How to do it…
How it works…
There's more…
See also
Using the Qlik Dev Hub in Qlik Sense® 2.1.1
Getting ready
How to do it…
Single configurator
Extensions editor
Mashup editor
How it works…
There's more…
Single configurator
Extension editor
See also
Using Extension editor in Qlik Dev Hub
Getting ready
How to do it…
How it works…
There's more…
See also
Using Qlik Dev Hub to generate mashups
Getting ready
How to do it…
How it works…
There's more…
See also
Embedding Qlik Sense® application on a website using a single configurator
Getting ready
How to do it…
How it works…
There's more…
See also
Using the Qlik DataMarket
Getting ready…
How to do it…
How it works…
See also
Creating dynamic charts in Qlik Sense®
Getting ready
How to do it…
How it works…
There's More….
Using Smart Search
Getting ready
How to do it…
How it works…
There's More….
See also
Using smart data load profiling
Getting ready
How to do it…
How it works…
There's More….
Conclusion
A. Appendix
Keyboard shortcuts in Qlik Sense® Desktop
Index
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset