Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from Qlik Sense Cookbook Over 80 recipes on data analytics to solve business intelligence challenges

Product type Paperback

Published in Aug 2018

Publisher Packt

ISBN-13 9781788997058

Length 334 pages

Edition 2nd Edition

Tools

Qlik Sense

Concepts

Business Intelligence

Authors (3):

Philip Hand

Neeraj Kharpate

Pablo Labbe

View More author details

Table of Contents (11) Chapters

Preface

1. Getting Started with the Data FREE CHAPTER

2. Visualizations

3. Scripting

4. Managing Apps and the User Interface

5. Useful Functions

6. Set Analysis

7. Using Extensions in Qlik Sense

8. Advanced Aggregation with AGGR

9. Tips and Tricks

10. Other Books You May Enjoy

Leave a review - let other readers know what you think

Advanced Aggregation with AGGR

In this chapter, we will focus on understanding what the AGGR function is and how to use it. The following topics will be covered:

Using nested aggregations
Using Rank() with Aggr
Combining set analysis with Aggr
Creating an ABC analysis

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (3)

Labbe

Pablo is a Business Intelligence Consultant with over 18 years of experience. In 2008 he was presented to Qlikview, the former product by Qlik and the seed for Qlik Sense. Since that year he was focused on delivering BI solutions in a new way. Now he is the Principal of ANALITIKA Inteligencia delivering BI projects and training focusing on Qlik products and other technologies that embrace the Self-Service BI. He is an active member of the Qlik Community and other social media sites. You can follow him on Twitter - @pablolabbe and LinkedIn.

See other products by Labbe

Kharpate

Neeraj Kharpate works as a Senior Business Intelligence consultant at Capventis, a QlikView Elite Partner. Having started his career working as a technical support executive for an aviation ERP, Neeraj embarked on his journey with Qlikview in mid-2007. He is a certified Qlikview designer, developer, and trainer. Neeraj has been closely following the developments in Qlik Sense ever since it was launched in 2014 and is extremely excited about the future of this product. Neeraj has completed his Masters in Business Administration from the Norwich Business School, University of East Anglia. He also has a diploma in Management Consulting from the Chartered Management Institute, UK.

See other products by Kharpate

Hand

Philip Hand is a Senior Business Intelligence consultant who has worked with QlikView in the BI space for over 7 years. Working with Qlik's top partner in the UK, he has implemented end-to-end solutions in a wide variety of enterprises and for large business customers. Philip has great experience and knowledge working across many sectors from the public sector, insurance, and financial services to large retailer and manufacturing businesses.

See other products by Hand