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
Advanced Aggregation with AGGR
by Neeraj Kharpate, Philip Hand, Pablo Labbe
Qlik Sense Cookbook - Second Edition
- Title Page
- Copyright and Credits
- Packt Upsell
- Contributors
- Preface
- Getting Started with the Data
- Introduction
- Extracting data from databases and data files
- Extracting data from web files
- Extracting data from the FTP server
- Extracting data from web services with REST Connector
- Activating the legacy mode in Qlik Sense® desktop
- Previewing data in the Data model viewer
- Creating a master library from the Data model viewer
- Using a master library in Edit mode
- Using visual data preparation on the data manager model viewer
- Visualizations
- Introduction
- Creating snapshots
- Creating and adding content to a story
- Adding embedded sheets to the story
- Highlighting the performance measure in a bar chart
- Associating persistent colors to field values using the script
- Using the colormix1 function
- Composition
- Relationships
- Comparison
- Distribution
- Structuring visualizations
- Measuring statistical data with box plot charts
- Using a waterfall chart to analyze the cumulative effect
- Scripting
- Introduction
- Structuring the script
- Efficiently debugging the script
- Packaging the code in script files
- How to use subroutines in Qlik Sense®
- Optimizing the UI calculation speed
- Optimizing the reload time of the application
- Using a For each loop to load data from multiple files
- Using the Concat() function to store multiple field values in a single cell
- Executing command-line programs within the script
- Managing Apps and the User Interface
- Introduction
- Publishing a Qlik Sense® application created in Qlik Sense® Desktop
- Creating private, approved, and community sheets
- Publishing a Qlik Sense® application to Qlik Sense® Cloud
- Creating geo maps in Qlik Sense®
- Reference lines in a Sales versus Target gauge chart
- Effectively using the KPI object in Qlik Sense®
- Creating treemaps
- Creating dimensionless bar charts in Qlik Sense®
- Adding reference lines to trendline charts
- Creating text and images
- Applying limitations to charts
- Adding thumbnails to a clear environment
- Navigating many data points in a scatter chart
- Using alternative dimensions and measures
- Using the visual exploration menu
- Useful Functions
- Introduction
- Using an extended interval match to handle slowly changing dimensions
- Using the Previous() function to identify the latest record read for a dimensional value
- Using the NetworkDays() function to calculate the working days in a calendar month
- Using the Concat() function to display a string of field values as a dimension
- Using the Minstring() function to calculate the age of the oldest case in a queue
- Using the RangeSum() function to plot cumulative figures in trendline charts
- Using the Fractile() function to generate quartiles
- Using the FirstSortedValue() function to identify the median in a quartile range
- Using the Declare and Derive functions to generate Calendar fields
- Setting up a moving annual total figure
- Using the For Each loop to extract files from a folder
- Using the Peek() function to create a currency exchange rate calendar
- Using the Peek() function to create a trial balance sheet
- Using the subfield() function to split field into multiple records
- Using the dual() function to set the sort order of dimensions
- Set Analysis
- Introduction
- 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 Cconcat() function in Set Analysis
- Using the element functions P() and E() in Set Analysis
- Using the intersection between sets for Basket Analysis
- Using alternate states
- Using Extensions in Qlik Sense
- Advanced Aggregation with AGGR
- Tips and Tricks
- Other Books You May Enjoy
Advanced Aggregation with AGGR
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.