Book Image

Mastering Qlik Sense

By : Martin Mahler, Juan Ignacio Vitantonio
Book Image

Mastering Qlik Sense

By: Martin Mahler, Juan Ignacio Vitantonio

Overview of this book

Qlik Sense is a powerful, self-servicing Business Intelligence tool for data discovery, analytics and visualization. It allows you to create personalized Business Intelligence solutions from raw data and get actionable insights from it. This book is your one-stop guide to mastering Qlik Sense, catering to all your organizational BI needs. You'll see how you can seamlessly navigate through tons of data from multiple sources and take advantage of the various APIs available in Qlik and its components for guided analytics. You'll also learn how to embed visualizations into your existing BI solutions and extend the capabilities of Qlik Sense to create new visualizations and dashboards that work across all platforms. We also cover other advanced concepts such as porting your Qlik View applications to Qlik Sense,and working with Qlik Cloud. Finally, you'll implement enterprise-wide security and access control for resources and data sources through practical examples. With the knowledge gained from this book, you'll have become the go-to expert in your organization when it comes to designing BI solutions using Qlik Sense.
Table of Contents (16 chapters)

Maintaining expressions

In small applications, maintaining expressions isn't a problem. Every time you want to modify something, you can open each chart and change the expressions. However, when you have many applications using the same or similar expressions, changing them one by one can become challenging.

A very simple and good way of maintaining expressions is to have them all in a centralized file. This can be an Excel file that you can then read. If anything changes, you must only change things in one place. The file also gives you a place to explain each of the expressions for further clarity.

Each expression will be stored in a variable, and the variable will then be used directly in the chart expressions.

The following is an example of an Excel file format containing the application expressions:

Variable name Environment Expression definition Active flag Comments...