Home Page Icon
Home Page
Table of Contents for
See also
Close
See also
by Neeraj Kharpate, Philip Hand, Pablo Labbe
Qlik Sense Cookbook - Second Edition
Title Page
Copyright and Credits
Qlik Sense Cookbook Second Edition
Packt Upsell
Why subscribe?
PacktPub.com
Contributors
About the authors
About the reviewer
Packt is searching for authors like you
Preface
Who this book is for
What this book covers
To get the most out of this book
Download the example code files
Download the color images
Conventions used
Sections
Getting ready
How to do it...
How it works...
There's more...
See also
Get in touch
Reviews
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…
Extracting data from the FTP server
Getting ready
How to do it…
How it works…
There's more…
See also…
Extracting data from web services with REST Connector
How to do it…
How it works…
There's more…
See also...
Activating the legacy mode in Qlik Sense® desktop
How it works…
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 metadata
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 Edit mode
Getting ready
How to do it…
There's more…
Using visual data preparation on the data manager model viewer
Getting ready
How to do it…
How it works…
There's more…
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 using the script
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…
Measuring statistical data with box plot charts
Getting ready
How to do it…
How it works…
Using a waterfall chart to analyze the cumulative effect
Getting ready
How to do it…
How it works…
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 subroutines 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
Executing command-line programs within the script
Getting ready
How to do it…
How it works…
There's more…
See also
Managing Apps and the 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 a 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 treemaps
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…
How it works…
Applying limitations to charts
Getting ready
How to do it…
How it works…
There's more…
Adding thumbnails to 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…
Using alternative dimensions and measures
Getting ready
How to do it…
How it works…
There's more…
Using the visual exploration menu
Getting ready
How to do it…
How it works…
There's more…
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 read 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
Using the subfield() function to split field into multiple records
Getting ready
How to do it…
How it works…
There's more…
See also
Using the dual() function to set the sort order of dimensions
Getting ready
How to do it...
How it works…
There's more…
See also
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 Cconcat() 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
Using the intersection between sets for Basket Analysis
Getting ready
How to do it…
How it works…
There's more…
See also
Using alternate states
Getting ready
How to do it…
How it works…
There's more...
See also
Using Extensions in Qlik Sense
Introduction
Finding extensions on Qlik Branch
Getting ready
How to do it…
How it works…
There's more…
See also
How to import extensions (Desktop and Server)
Getting ready
How to do it…
How it works…
There's more…
Using the Variable extension
Getting ready
How to do it…
How it works…
There's more…
Using the Reload button extension
Getting ready
How to do it…
How it works…
There's more…
Using the simple KPI extension
Getting ready
How to do it…
How it works…
There's more…
Using the ShowHide Container extension
Getting ready
How to do it…
How it works…
There's more…
Advanced Aggregation with AGGR
Introduction
Using nested aggregations
Getting ready
How to do it…
How it works…
There's more…
See also
Using Rank() with Aggr
Getting ready
How to do it…
How it works…
There's more…
See also
Combining set analysis with Aggr
Getting ready
How to do it…
How it works…
There's more…
See also
Creating an ABC analysis
Getting ready
How to do it…
How it works…
There's more…
See also
Tips and Tricks
Introduction
Working with multiple tabs
Getting ready
How to do it…
How it works…
There's more…
See also
Using the keyboard to navigate and interact
Getting ready
How to do it…
How it works…
There's more…
Working with the distinct clause
Getting ready
How it works…
There's more…
Managing variables in the script and layout
Getting ready
How to do it…
How it works…
There's more…
Using measure names in object expressions
Getting ready
How to do it…
How it works…
There's more…
Creating dynamic charts
Getting ready
How to do it…
How it works…
There's more…
Other Books You May Enjoy
Leave a review - let other readers know what you think
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
There's more…
Next
Next Chapter
Associating persistent colors to field values using the script
See also
Using the colormix1 function
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