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)

Formatting settings through variables

Before we start coding, we should first set the foundations that will allow us to properly set up formats as well as ways of handling values, for example, nulls or dates. This is important because different regions have different formats. Let's take the United States as an example. Numbers in the United States use commas to represent thousands and dots to represent decimals. For example, one thousand and thirty hundredths in its numerical form is 1,000.30. However, most of the countries in Latin America would use dots as a thousand separator and commas for hundredths separators: 1.000,30.

Another very important value where the format changes depending on the region is the date. Dates can be represented in different ways. For example, 2018-08-08 where we have four digits for the year, two for the month, and two for the day, or 30-01-2019...