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.

  • What our Students say

    A really enjoyable experience; I feel privileged to be trained by the best!

  • What our Students say

    Honestly, I attended both Designer and Developer training through Qlikview and found your course to be much more focused and thorough. The presentation was straight forward, the exercises were well thought out, the instructor was engaging and made the course feel like it was flying by - in a good way! Thank you!

  • What our Students say

    Barry is awesome.  He responded to all questions with clear and concise answers and made sure we all understood the material.

  • What our Students say

    A good course that covered quite a bit during 2.5h. I got some good tips to problems which I’ve already ran into. All-in-all definitely worth the price.  

  • What our Students say

    The training was excellent and really helpful to understand the topics. I hope I will be able to easily use my new knowledge in further QV applications I'll develop.

  • What our Students say

    Barry is fantastic and very patient. He rocks.

  • What our Students say

    Well worth it.  Delivered a great value to customers.

  • What our Students say

    Great training. Barry answered the questions well.

  • What our Students say

    I did download your Kindle book onto my tablet previously, but the combination of reading how to do something, having it verbally explained, and then working through some exercises was a great combination.

  • What our Students say

    I just wanted to say “Thank you” for this Course,  I got a lots of idea that I can improve our current Data Models and Dashboards

  • What our Students say

    Some tricks that he has showed us were really neat.  Write script once and use it on all dashboards!

  • What our Students say

    I picked up several tips for using QlikView overall, particularly in the area of best practices.  I finished the class Friday afternoon and immediately put it to use Monday morning.

  • What our Students say

    The training I received in the set analysis call was invaluable.  I was into new territory by the time Barry was on his third slide, so needless to say I learned a lot in 3 hours.

Course Syllabus

Set Analysis: An introduction

  • Basic Syntax
  • Set identifiers
  • Set modifiers
  • Element lists

Basic Examples

Empty section. Edit page to add content here.

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

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?