Take advantage of one of QlikView™’s most powerful functionalities. Set Analysis expressions can dramatically boost an app’s analytical power, enabling complex calculations in a simple and straight-forward fashion. Mastering this tool is the objective of this training session, after which every student will have the ability to understand and create set analysis expressions up to an advanced level. This session contains a set of exercises to help students learn each concept and even put it to practice by creating charts and objects for point in time reporting. Another important topic covered in this course is the creation of comparative analysis scenarios and the use of alternate states.
As this course is highly practical, we provide example files to be used on each exercise, as well as solutions files for students to compare their results.
- Learn to build Set Analysis expressions, from theory to practice.
- Learn to create expressions for period over period comparisons using Set Analysis.
- Uncover the tricks to simplify the creation of set expressions and efficiently manage them in a multi-app environment.
- Learn to create state-based expressions and take advantage of the alternate states functionality.
Click on a Session To Register
BI Consultant, Author and Trainer
Barry is an independent Business Intelligence Consultant based in the Netherlands. Originally from a background of traditional Business Intelligence, Data Warehousing, and Performance Management, in 2008 he made the shift to QlikView and a more user-centric form of Business Intelligence.
Since switching over to QlikView, Barry has completed many successful implementations in many different industries, from Financial Services to Telecoms, and from Manufacturing to Healthcare. Barry’s QlikView experience covers a wide variety of roles and subjects; requirements analysis, design, development, architecture, infrastructure, system administration, integration, project management and training.
- Set Analysis: An Introduction
- Basic Syntax
- Set Identifiers
- Set modifiers
- Element lists
- Basic Examples
- Advanced Syntax
- Using variables in set expressions
- Dynamic record sets
- Using assignment operators
- Using set operators
- Element functions
- Set Analysis and Point In Time Reporting
- Tips for creating point in time reporting expressions
- Point in time reporting and the master calendar
- Hands-on exercise
- General Tips
- Validating set expressions