Qlik Sense® Cookbook

Over 80 step-by-step recipes to tackle the everyday challenges faced by Qlik Sense® developers

Qlik Sense® Cookbook

This ebook is included in a Mapt subscription
Philip Hand, Neeraj Kharpate

2 customer reviews
Over 80 step-by-step recipes to tackle the everyday challenges faced by Qlik Sense® developers
$0.00
$16.00
$39.99
$29.99p/m after trial
RRP $31.99
RRP $39.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 4,000+ eBooks & Videos
  • 40+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Book Details

ISBN 139781782175148
Paperback290 pages

Book Description

This book is an excellent guide for all aspiring Qlik Sense® developers. It will take you through the basics, right through to the use of more advanced functions. With the recipes in this book, you will be empowered to create fully featured desktop applications in Qlik Sense®.

Starting with a quick refresher on obtaining data from data files and databases, this book moves on to the more refined features of Qlik Sense®, including visualization, scripting, and set analysis. The tips and tricks provided will help you to overcome challenging situations while developing your applications in Qlik Sense®. This and more will help you to deliver engaging dashboards and reports efficiently.

By the end of the book, you will be an expert user of Qlik Sense® and will be able to use its features effectively for business intelligence in an enterprise environment.

Table of Contents

Chapter 1: Getting Started with the Data
Introduction
Extracting data from databases and data files
Extracting data from Web Files
Activating the Legacy Mode in Qlik Sense desktop
Extracting data from custom databases
Invoking help while in the data load editor or the expression editor
Previewing data in the Data model viewer
Creating a Master Library from the Data model viewer
Using a Master Library in the Edit mode
Chapter 2: Visualizations
Introduction
Creating Snapshots
Creating and adding content to a story
Adding embedded sheets to the story
Highlighting the performance measure in a bar chart
Associating persistent colors to field values
Using the ColorMix1 function
Composition
Relationships
Comparison
Distribution
Structuring visualizations
Chapter 3: Scripting
Introduction
Structuring the script
Efficiently debugging the script
Packaging the code in script files
How to use sub routines in Qlik Sense
Optimizing the UI calculation speed
Optimizing the reload time of the application
Using a For Each loop to load data from multiple files
Using the Concat function to store multiple field values in a single cell
Chapter 4: Managing Apps and User Interface
Introduction
Publishing a Qlik Sense application created in Qlik Sense desktop
Creating private, approved, and community sheets
Publishing a Qlik Sense application to Qlik Sense cloud
Creating geo maps in Qlik Sense
Reference lines in Sales versus Target gauge chart
Effectively using the KPI object in Qlik Sense
Creating Tree Maps
Creating dimensionless bar charts in Qlik Sense
Adding Reference Lines to trendline charts
Creating text and images
Applying limitations to charts
Adding thumbnails – a clear environment
Navigating many data points in a scatter chart
Chapter 5: Useful Functions
Introduction
Using an extended interval match to handle Slowly Changing Dimensions
Using the Previous() function to identify the latest record for a dimensional value
Using the NetworkDays() function to calculate the working days in a calendar month
Using the Concat() function to display a string of field values as a dimension
Using the Minstring() function to calculate the age of the oldest case in a queue
Using the Rangesum() function to plot cumulative figures in trendline charts
Using the Fractile() function to generate quartiles
Using the FirstSortedValue() function to identify the median in a quartile range
Using the Declare and Derive functions to generate Calendar fields
Setting up a moving annual total figure
Using the For Each loop to extract files from a folder
Using the Peek() function to create a currency Exchange Rate Calendar
Using the Peek() function to create a Trial Balance sheet
Chapter 6: Set Analysis
Introduction
Cracking the syntax for Set Analysis
Using flags in Set Analysis
Using the = sign with variables in Set Analysis
Point in time using Set Analysis
Using comparison sets in Set Analysis
Using embedded functions in Set Analysis
Creating a multi-measure expression in Set Analysis
Using search strings inside a set modifier
Capturing a list of field values using a concat() function in Set Analysis
Using the element functions P() and E() in Set Analysis
Chapter 7: Extensions in Qlik Sense
Introduction
Creating an HTML visualization extension for Qlik Sense
Defining a Properties panel in Qlik Sense visualizations
Creating custom components within Qlik Sense visualizations
Using data with extensions
Chapter 8: What's New in Version 2.1.1?
Introduction
Using the visual exploration capability in Qlik Sense 2.1.1
Defining variables in Qlik Sense
Exporting stories to MS PowerPoint
Using the Qlik Dev Hub in Qlik Sense 2.1.1
Using Extension editor in Qlik Dev Hub
Using Qlik Dev Hub to generate mashups
Embedding Qlik Sense application on a website using a single configurator
Using the Qlik DataMarket
Creating dynamic charts in Qlik Sense
Using Smart Search
Using smart data load profiling
Conclusion

What You Will Learn

  • Source, load, preview, and distribute your organization’s information
  • Maximize the effect of visualizations for different types of data
  • Get to grips with the new visualization functions and add bespoke features not covered in the standard options
  • Leverage scripting tools, techniques, and best practices that once implemented, never stop adding value
  • Make your user interface more advanced and intuitive with various custom objects and indicators
  • Explore various tips and tricks of navigation for the Qlik Sense® frontend
  • Develop creative extensions for your Qlik Sense® dashboard

Authors

Table of Contents

Chapter 1: Getting Started with the Data
Introduction
Extracting data from databases and data files
Extracting data from Web Files
Activating the Legacy Mode in Qlik Sense desktop
Extracting data from custom databases
Invoking help while in the data load editor or the expression editor
Previewing data in the Data model viewer
Creating a Master Library from the Data model viewer
Using a Master Library in the Edit mode
Chapter 2: Visualizations
Introduction
Creating Snapshots
Creating and adding content to a story
Adding embedded sheets to the story
Highlighting the performance measure in a bar chart
Associating persistent colors to field values
Using the ColorMix1 function
Composition
Relationships
Comparison
Distribution
Structuring visualizations
Chapter 3: Scripting
Introduction
Structuring the script
Efficiently debugging the script
Packaging the code in script files
How to use sub routines in Qlik Sense
Optimizing the UI calculation speed
Optimizing the reload time of the application
Using a For Each loop to load data from multiple files
Using the Concat function to store multiple field values in a single cell
Chapter 4: Managing Apps and User Interface
Introduction
Publishing a Qlik Sense application created in Qlik Sense desktop
Creating private, approved, and community sheets
Publishing a Qlik Sense application to Qlik Sense cloud
Creating geo maps in Qlik Sense
Reference lines in Sales versus Target gauge chart
Effectively using the KPI object in Qlik Sense
Creating Tree Maps
Creating dimensionless bar charts in Qlik Sense
Adding Reference Lines to trendline charts
Creating text and images
Applying limitations to charts
Adding thumbnails – a clear environment
Navigating many data points in a scatter chart
Chapter 5: Useful Functions
Introduction
Using an extended interval match to handle Slowly Changing Dimensions
Using the Previous() function to identify the latest record for a dimensional value
Using the NetworkDays() function to calculate the working days in a calendar month
Using the Concat() function to display a string of field values as a dimension
Using the Minstring() function to calculate the age of the oldest case in a queue
Using the Rangesum() function to plot cumulative figures in trendline charts
Using the Fractile() function to generate quartiles
Using the FirstSortedValue() function to identify the median in a quartile range
Using the Declare and Derive functions to generate Calendar fields
Setting up a moving annual total figure
Using the For Each loop to extract files from a folder
Using the Peek() function to create a currency Exchange Rate Calendar
Using the Peek() function to create a Trial Balance sheet
Chapter 6: Set Analysis
Introduction
Cracking the syntax for Set Analysis
Using flags in Set Analysis
Using the = sign with variables in Set Analysis
Point in time using Set Analysis
Using comparison sets in Set Analysis
Using embedded functions in Set Analysis
Creating a multi-measure expression in Set Analysis
Using search strings inside a set modifier
Capturing a list of field values using a concat() function in Set Analysis
Using the element functions P() and E() in Set Analysis
Chapter 7: Extensions in Qlik Sense
Introduction
Creating an HTML visualization extension for Qlik Sense
Defining a Properties panel in Qlik Sense visualizations
Creating custom components within Qlik Sense visualizations
Using data with extensions
Chapter 8: What's New in Version 2.1.1?
Introduction
Using the visual exploration capability in Qlik Sense 2.1.1
Defining variables in Qlik Sense
Exporting stories to MS PowerPoint
Using the Qlik Dev Hub in Qlik Sense 2.1.1
Using Extension editor in Qlik Dev Hub
Using Qlik Dev Hub to generate mashups
Embedding Qlik Sense application on a website using a single configurator
Using the Qlik DataMarket
Creating dynamic charts in Qlik Sense
Using Smart Search
Using smart data load profiling
Conclusion

Book Details

ISBN 139781782175148
Paperback290 pages
Read More
From 2 reviews

Read More Reviews