Qlik Sense Cookbook - Second Edition

Qlik Sense Cookbook - Second Edition

By : Pablo Labbe, Philip Hand, Neeraj Kharpate

Buy this Book

Qlik Sense Cookbook - Second Edition

By: Pablo Labbe, Philip Hand, Neeraj Kharpate

Buy this Book

Overview of this book

Qlik Sense allows you to explore simple and complex data to reveal hidden insight and data relationships that help you make quality decisions for overall productivity. An expert Qlik Sense user can use its features for business intelligence in an enterprise environment effectively. Qlik Sense Cookbook is an excellent guide for all aspiring Qlik Sense developers and will empower you to create featured desktop applications to obtain daily insights at work. This book takes you through the basics and advanced functions of Qlik Sense February 2018 release. You’ll start with a quick refresher on obtaining data from data files and databases, and move on to some more refined features including visualization, and scripting, as well as managing apps and user interfaces. You will then understand how to work with advanced functions like set analysis and set expressions. As you make your way through this book, you will uncover newly added features in Qlik Sense such as new visualizations, label expressions and colors for dimension and measures. By the end of this book, you will have explored various visualization extensions to create your own interactive dashboard with the required tips and tricks. This will help you overcome challenging situations while developing your applications in Qlik Sense.

Title Page

Packt Upsell

Contributors

Preface

Free Chapter

Getting Started with the Data

Introduction

Extracting data from databases and data files

Extracting data from web files

Extracting data from the FTP server

Extracting data from web services with REST Connector

Activating the legacy mode in Qlik Sense® desktop

Previewing data in the Data model viewer

Creating a master library from the Data model viewer

Using a master library in Edit mode

Using visual data preparation on the data manager model viewer

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 script

Using the colormix1 function

Structuring visualizations

Measuring statistical data with box plot charts

Using a waterfall chart to analyze the cumulative effect

Scripting

Introduction

Structuring the script

Efficiently debugging the script

Packaging the code in script files

How to use subroutines 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

Executing command-line programs within the script

Managing Apps and the 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 a Sales versus Target gauge chart

Effectively using the KPI object in Qlik Sense®

Creating treemaps

Creating dimensionless bar charts in Qlik Sense®

Adding reference lines to trendline charts

Creating text and images

Applying limitations to charts

Adding thumbnails to a clear environment

Navigating many data points in a scatter chart

Using alternative dimensions and measures

Using the visual exploration menu

Useful Functions

Introduction

Using an extended interval match to handle slowly changing dimensions

Using the Previous() function to identify the latest record read 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

Using the subfield() function to split field into multiple records

Using the dual() function to set the sort order of dimensions

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 Cconcat() function in Set Analysis

Using the element functions P() and E() in Set Analysis

Using the intersection between sets for Basket Analysis

Using alternate states

Using Extensions in Qlik Sense

Introduction

Finding extensions on Qlik Branch

How to import extensions (Desktop and Server)

Using the Variable extension

Using the Reload button extension

Using the simple KPI extension

Using the ShowHide Container extension

Advanced Aggregation with AGGR

Introduction

Using nested aggregations

Using Rank() with Aggr

Combining set analysis with Aggr

Creating an ABC analysis

Tips and Tricks

Introduction

Working with multiple tabs

Using the keyboard to navigate and interact

Working with the distinct clause

Managing variables in the script and layout

Using measure names in object expressions

Creating dynamic charts

Other Books You May Enjoy

Leave a review - let other readers know what you think

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Contributors

About the authors

Pablo Labbe is a BI consultant with over 20 years' experience. In 2008 he was introduced to Qlikview, a former product by Qlik and the seed for Qlik Sense. Since then, he has focused on delivering BI solutions in a new way. Now he is the Principal of ANALITIKA Inteligencia, delivering BI projects and training on Qlik products and other technologies that embrace the self-service BI. Pablo is an active member of the Qlik community and other social media sites.

I want to thank the people who have been close to me and supported me, especially my wife, Daniela, and my children.

Philip Hand is a senior BI consultant who has worked with QlikView in the BI space for over 7 years. He has implemented end-to-end solutions in a wide variety of enterprises and for large business customers. He has spent many years consulting on business and QlikView solutions. His belief is that such a role proves invaluable to hone your skills through exposure to many different businesses, problems, technologies, industries, and people.

Neeraj Kharpate works as an independent BI consultant providing services to clients from various industries. Neeraj embarked on his journey with Qlik in mid-2007. He has over 10 years of experience working with clientele from multiple sectors, ranging from banks and insurance to retail. Neeraj has been closely following the developments in Qlik Sense ever since it was launched in 2014 and is actively involved with its enterprise-wide implementations.

About the reviewer

Marcio Lins was born in Guarabira, Brazil, on June 21, 1983. He is the founder of the IMWTI (2012), a Qlik solution provider partner, a Certified Scrum Master, and a Qlik developer leader. He has worked more than 10 ERP and other technologies (PHP, C#, and Clipper). He specializes in the Qlik API, from bots to integration with corporate systems.

Packt is searching for authors like you

If you're interested in becoming an author for Packt, please visit authors.packtpub.com and apply today. We have worked with thousands of developers and tech professionals, just like you, to help them share their insight with the global tech community. You can make a general application, apply for a specific hot topic that we are recruiting an author for, or submit your own idea.

Qlik Sense Cookbook - Second Edition

By : Pablo Labbe, Philip Hand, Neeraj Kharpate

Qlik Sense Cookbook - Second Edition

By: Pablo Labbe, Philip Hand, Neeraj Kharpate

Overview of this book

Related Content you might be interested in

Current Title:

Qlik Sense Cookbook - Second Edition

Hands-On Business Intelligence with Qlik Sense

Mastering Qlik Sense

QlikView for Developers

Contributors

About the authors

About the reviewer

Packt is searching for authors like you