Book Image

Qlik Sense: Advanced Data Visualization for Your Organization

By : Henric Cronström, Ferran Garcia Pagans, Neeraj Kharpate, James Richardson, Philip Hand
Book Image

Qlik Sense: Advanced Data Visualization for Your Organization

By: Henric Cronström, Ferran Garcia Pagans, Neeraj Kharpate, James Richardson, Philip Hand

Overview of this book

Qlik Sense is powerful and creative visual analytics software that allows users to discover data, explore it, and dig out meaningful insights in order to make a profit and make decisions for your business. This course begins by introducing you to the features and functions of the most modern edition of Qlik Sense so you get to grips with the application. The course will teach you how to administer the data architecture in Qlik Sense, enabling you to customize your own Qlik Sense application for your business intelligence needs. It also contains numerous recipes to help you overcome challenging situations while creating fully featured desktop applications in Qlik Sense. It explains how to combine Rattle and Qlik Sense Desktop to apply predictive analytics to your data to develop real-world interactive data applications. The course includes premium content from three of our most popular books: [*] Learning Qlik Sense: The Official Guide Second Edition [*] Qlik Sense Cookbook [*] Predictive Analytics using Rattle and Qlik Sense On completion of this course, you will be self-sufficient in improving your data analysis and will know how to apply predictive analytics to your datasets. Through this course, you will be able to create predictive models and data applications, allowing you to explore your data insights much deeper.
Table of Contents (5 chapters)

Chapter 6. Set Analysis

In this chapter, we will focus on the concept of Set Analysis and its use in Qlik Sense. We will cover the following topics:

  • 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 concat() function in Set Analysis
  • Using the element functions P() and E() in Set Analysis

Introduction

I will say it outright that Set Analysis is one of the most important technical features of Qlik solutions. It allows you to do things dynamically that just won't be possible with the default selections you have made. Set analysis can be termed as Selection analysis. The user tells Qlik Sense what set of records need to be picked for calculation which is similar to making a selection...