Book Image

Mastering Qlik Sense

By : Juan Ignacio Vitantonio
Book Image

Mastering Qlik Sense

By: 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)

Advanced Expressions in Qlik Sense

Expressions are an essential part of any chart. There would be no output without expressions, and the results of any output will be conditioned by the accuracy of the expressions.

We usually find expressions in the script as well as in any chart. We described script expressions in Chapter 8, Advanced Scripting, and we will cover chart expressions in more detail in this chapter.

An expression can be defined as a group of functions, fields, and operators that, after being evaluated, will return a number or string. We can find expressions not only within the measures of any chart but also in labels, titles, and so on. If you see the icon in a chart, it means that not only a string but also an expression can be used.

The following is an example of an expression:

SUM( [Gross Sales] * 1.2 )

The previous expression contains three elements:

  • The function...