QlikView™ Set Analysis

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.

Learning Objectives

  • 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

No Events

The Instructor

Barry Harmsen

Barry Harmsen

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.

Course Syllabus

  1. Set Analysis: An Introduction
    • Basic Syntax
    • Set Identifiers
    • Set modifiers
    • Element lists
  2. Basic Examples
  3. Advanced Syntax
    • Using variables in set expressions
    • Dynamic record sets
    • Using assignment operators
    • Using set operators
    • Element functions
  4. 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
  5. General Tips
    • Validating set expressions

Course Details

Barry Harmsen
4 hours
USD $199
Live, Instructor-led, Online
Developers, Power Users
Developer, Expressions, Set Analysis

Course Highlights

  • Example and solution files
  • Hands-on exercises
  • Learn by doing

Get the latest!

Not quite ready to enroll now? No problem, you can also sign up with your email to stay in the loop and receive fresh updates about upcoming courses and sessions.

Please wait...
Send a message

Have a question? We're currently offline but leave us a message here and we'll get back to you.

Your name
* Email
* Describe your issue
Login now

Questions? We're here. Send us a message!

Your name
* Email
* Describe your issue
We're online!

Help us help you better! Feel free to leave us any additional feedback.

How do you rate our support?