The book is for anyone who has been exposed to Qlik Sense® and wants to start using it actively for BI. Anybody with prior knowledge of its sister product, QlikView, will also benefit from this book. Familiarity with the basics of BI is a prerequisite.

Chapter 1, Getting Started with the Data, introduces the reader to different methods of loading data into Qlik Sense from various sources, such as relational databases, data files, FTP server, and web services. We will also delve into the creation and usage of Master Library in Qlik Sense and Data Manager for data preparation without code.

Chapter 2, Visualizations, focuses on the best design practices in Qlik Sense in order to create engaging applications. It also looks at the concepts of snapshots and stories in Qlik Sense.

Chapter 3, Scripting, introduces the reader to the techniques of writing a well-structured script in Qlik Sense. It discusses and explains the benefits of concepts such as subroutines, script files, and loops in scripts, which all form a part of the arsenal of a good Qlik Sense developer.

Chapter 4, Managing Apps and the User Interface, introduces the reader to the concept of publishing the Qlik Sense apps on the server and Qlik Sense cloud. We will also look at certain key Qlik Sense objects and using them for the right purpose and to convey the right information.

Chapter 5, Useful Functions, deals with some very useful functions that are available in Qlik Sense. We present some challenging scenarios that a Qlik Sense developer faces and provide solutions for them.

Chapter 6, Set Analysis, is one of the most powerful concepts in Qlik Sense. This chapter explains the process of writing Set Analysis expressions from scratch. We will also look at some advanced variations in Set Analysis expressions, such as the introduction of flags, defining ranges using the Concat() function in Set Analysis expressions, using P() and E() for indirect selections, set operators, and alternative states.

Chapter 7, Using Extensions in Qlik Sense, focuses on managing and using the most useful extensions in your Qlik Sense apps, such as reload app, action buttons, variable input box, KPI visualization, and object containers, which conditionally show and hide objects.

Chapter 8, Advanced Aggregation with AGGR, discuss when and how to use AGGR with some useful recipes, such as Ranking and ABC Analysis.

Chapter 9, Tips and Tricks, contains recipes to improve your day-to-day productivity using Qlik Sense.

Qlik Sense Cookbook requires you to have at least a basic understanding of Qlik Sense. You should have either already deployed a couple of Qlik Sense apps or have worked extensively with QlikView before if you are now looking to transition to Qlik Sense.

To make the most out of this book, you don't necessarily read it from the beginning until the end (although it's recommended), but you should feel encouraged to start a chapter you're interested in and follow all recipes until the end because some recipe depends on the previous ones. Cross-references between recipes are made to ensure you know where to continue your reading if you wish to deepen your knowledge.

To closely follow the practical examples and to make the most of the code snippets, please ensure you download the latest version of the Qlik Sense Desktop client from the official website, which can be found here  https://www.qlik.com/us/try-or-buy/download-qlik-sense.

In the time of writing the book, several versions of Qlik Sense were launched introducing new features but also changes to the UI. At the time of writing of the book, we were using Qlik Sense version February/2018. We carefully wrote the recipes to work correctly with the most recent versions, but the recipe about geo map will not work with the current steps presented because theMapobject was entirely updated in version April/2018 and June/2018.

EmployeeInt:
LOAD *,
if([EmployeeID]= previous([EmployeeID]),'No','Yes') AS
LatestRecordFlag
RESIDENT EmployeeIntTemp
ORDER BY [EmployeeID] ASC, PositionFrom DESC;
DROP TABLE EmployeeIntTemp;

EmployeeInt:
LOAD *,
if([EmployeeID]= previous([EmployeeID]),'No','Yes') AS
LatestRecordFlag
RESIDENT EmployeeIntTemp
ORDER BY [EmployeeID] ASC, PositionFrom DESC;
DROP TABLE EmployeeIntTemp;

In this book, you will find several headings that appear frequently (Getting ready, How to do it..., How it works..., There's more..., and See also).

To give clear instructions on how to complete a recipe, use these sections as follows:

Feedback from our readers is always welcome.

General feedback: Email [email protected] and mention the book title in the subject of your message. If you have questions about any aspect of this book, please email us at [email protected].

Errata: Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you have found a mistake in this book, we would be grateful if you would report this to us. Please visit www.packtpub.com/submit-errata, selecting your book, clicking on the Errata Submission Form link, and entering the details.

Piracy: If you come across any illegal copies of our works in any form on the internet, we would be grateful if you would provide us with the location address or website name. Please contact us at [email protected] with a link to the material.

If you are interested in becoming an author: If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, please visit authors.packtpub.com.