Mastering QlikView Set Analysis
4.5 (118 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
516 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Mastering QlikView Set Analysis to your Wishlist.

Add to Wishlist

Mastering QlikView Set Analysis

Deep Dive Set Analysis Course for QlikView and Qlik Sense Developers
4.5 (118 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
516 students enrolled
Last updated 1/2017
Current price: $48 Original price: $195 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 5.5 hours on-demand video
  • 18 Articles
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Master Set Analysis syntax and write Set Analysis expressions with confidence
  • Set Modifier Deep Dive
  • Learn how to use Set Identifiers, Modifiers and Operators in Set Analysis Expression
  • Learn how to use Dollar-sign, Double Dollar-Sign expansion, expressions within Set Modifier
  • Learn how to use Alternate States with Set Analysis
  • Learn Useful functions with Set Analysis advanced aggregations
View Curriculum
  • QlikView development

Are you afraid of using one of the most power QlikView or Qlik Sense functionalities, Set Analysis, to build powerful QlikView or Qlik Sense applications because its syntax is daunting? You are not alone!

This course will teach you step-by-step to master Set Analysis so that you can start writing advanced aggregation expressions in QlikView and Qlik Sense with ease!

You will learn basics of Set Analysis first and then dive into advanced Set Analysis concepts to leverage this powerful advanced aggregation functionality in your QlikView or Qlik Sense application.

Who is the target audience?
  • QlikView developers
  • Business Analysts
  • QlikView designers
Compare to Other Qlikview Courses
Curriculum For This Course
66 Lectures
Getting Started
3 Lectures 13:30

1.2: Setup - Loading QVD Files

1.3: Associative Model
Set Analysis Fundementals
10 Lectures 01:08:59

2.2: Visual Representation of Set Analysis

2.3: Set Theory Refresher

2.4: Conceptual Aside - Set Identifier

Set Identifier
3 questions

2.5: Conceptual Aside - Set Operator

Set Operator
2 questions

2.6 - Challenge - Set Identifier (Introduction)

2.6: Challenge - Set Identifier

2.7: Solution - Set Identifier

2.8: Challenge - Set Operator

2.9: Solution - Set Operator
Set Modifier Deep Dive
21 Lectures 01:51:55
3.1: Conceptual Aside - Set Modifier

3.2: Challenge - Set Modifier

3.3: Solution - Set Modifier

Set Modifier
2 questions

3.4: Conceptual Aside - Two or More Set Modifiers

3.5: Challenge - Two or More Set Modifiers

3.6: Solution - Two or More Set Modifiers Part I

3.6: Solution - Two or More Set Modifiers Part II

Two or More Set Modifiers
2 questions

3.7: Challenge - Set Modifiers with Wild Card

3.8: Solution - Set Modifiers with Wild Card

3.9: Conceptual Aside - Set Modifiers with Range

3.10: Challenge - Set Modifiers with Range

3.11: Solution - Set Modifiers with Range

Set Modifier with Range
2 questions

3.12: Conceptual Aside - Nested Expressions

3.13: Challenge - Nested Expressions

3.14: Solution - Nested Expressions

Lesson 3.14: Challenge 11 Revised solution

Nested Expessions
2 questions

3.15: Challenge - Advanced Set Modifier

3.16: Solution - Advanced Set Modifier

3.17: Conceptual Aside - Element Functions P() and E()

3.18: Challenge - Element Functions P() and E()

3.19: Solution - Element Functions P() and E()

Element Functions - P() and E()
2 questions
Advanced Set Analysis
15 Lectures 01:06:06
4.1: Conceptual Aside - Dollar Sign Expansion

Dollar Sign Expansion
2 questions

4.2: Conceptual Aside - Double Dollar Sign Expansion

4.3: Conceptual Aside - Parameterized Dollar Sign Expansion

Parameterized Dollar Sign Expansion
2 questions

4.4: Conceptual Aside - Set Exclusions

Set Exclusion
2 questions

4.5: Conceptual Aside - Dealing with NULL values

Dealing with NULL values
2 questions

4.6: Conceptual Aside - Set Analysis with Alternate States

Set Analysis with Alternate States
2 questions

4.7: Conceptual Aside - Compare two fields

4.8: Conceptual Aside - Interesting operators

Interesting Operators
2 questions

4.9: Conceptual Aside - Set Modifier with an Expression

Set Modifier with an Expression
2 questions

Lesson 4.10: Challenge - Set Analysis with Alternate States

Lesson 4.11: Solution - Set Analysis with Alternate States

Challenge 4.12: Exclusion operator

Create a Line chart that shows sales for all product categories except Condiments, Confections, Grains and Cereals.

Even if user selects any of those categories, it should be excluded

Hint: Use -= operator. 

Lesson 4.12: Challenge - Exclusion operators

Lesson 4.13: Solution - Exclusion operators

Lesson 4.14: Challenge - Compare two fields

Lesson 4.15: Solution - Compare two fields
Useful Set Functions
16 Lectures 01:17:23
5.1: Conceptual Aside - Aggr()

Aggr() Function
2 questions

5.2: Challenge I - Aggr()

5.2: Challenge II - Aggr()

5.2: Challenge III - Aggr()

5.3: Solution I - Aggr()

5.3: Solution II - Aggr()

5.3: Solution III - Aggr()

5.4: Conceptual Aside - Concat()

Concat() Function
3 questions

5.5: Challenge - Concat()

5.6: Solution - Concat()

5.7: Conceptual Aside: FirstSortedValue()

5.8: Challenge 1 - FirstSortedValue()

5.8: Solution 1 - FirstSortedValue()

5.9: Challenge 2 - FirstSortedValue()

5.9: Solution 2 - FirstSortedValue()

1 Lecture 00:03
Mastering QlikView Set Analysis Guide: Syntax and Examples
About the Instructor
Vertechs .IO
4.5 Average rating
288 Reviews
1,048 Students
3 Courses

Note: Any coupon requests, please contact DV or Shilpan directly.

At Vertechs, our mission is to teach, learn and inspire. We teach QlikView and Qlik Sense and contribute to charity that educates underprivileged kids.

Vertechs means convergence of three focus points.

Our instructors have over 10 years of combined QlikView experience so our courses include their practical experience that can help students to learn and master QlikView quickly.

Deepak Vadithala (aka DV):

DV is a highly skilled and talented architect and developer. Over his 12 years’ experience, DV has continually developed his skills in many areas through both theory and practice, including SQL/BI within Business Intelligence, Data Management, ETL and Report Development/Automation. His specialities include Qlikview 11, QlikSense, HTML, CSS, JavaScript, SQL Server, T-SQL, SSIS, SPSS, Dreamweaver, Photoshop, Illustrator, MS Access, Excel VBA and Google Analytics. He has become an ‘aficionado’ of QlikView, a sophisticated and globally recognised Business Intelligence platform application. DV is a certified Qlik 11 Designer, Developer and Administrator. His Honors and Awards also include:

  • Qlik Luminary 2014 and 2017
  • QlikView application nominated for Gartner BI Awards 2012
  • QlikView application presented during business discovery event 2012
  • Certified Scrum Master (PSM)
  • Ranked within top 40 contributors on QlikView Community
  • Microsoft Certified Technology Specialist (MCTS)
  • Technical Reviewer for QlikView Scripting Book
  • Microsoft Certified Professional
  • JavaScript Enthusiast and Community Contributor

Shilpan Patel:

Shilpan is passionate about sharing QlikView knowledge. He has over 15 years of experience in business intelligence under his belt. Shilpan has broader experience in various verticals including finance, manufacturing, insurance and healthcare.

Shilpan is a certified Qlik 11 Developer and Designer.

Shilpan Patel
4.1 Average rating
1,557 Reviews
6,442 Students
5 Courses
Certified QlikView Developer and Designer

Greetings! I am a Certified QlikView Developer and Designer /Certified Qlik Sense Data Architect/ Certified QlikView System Administrator with over 15 years of experience in Business Intelligence, data warehousing and various relational database management systems.

With incredible data growth -- both structured and unstructured -- businesses struggle to make sense of data. Business discovery tools such as QlikView and Tableau offer new opportunities to those who want to help an enterprise make insight driven decisions. That's my passion and that's my life long purpose.

I enjoy sharing my knowledge in the field of Business Discovery and visual data analytics at my blog. I have developed and implemented numerous QlikView applications for banking, health care and manufacturing.

My goal is to make you an awesome QlikView Developer!

Deepak Vadithala (DV)
4.5 Average rating
288 Reviews
1,048 Students
3 Courses
Data Analytics Lead at Exterion| Data Achitect at Jefferies

I am currently working as a Qlik/BI Architect and managing a team of Developers. I am recognised as a Qlik Luminary for the year 2014 and 2017. Co-Founded Qlik Dev Group and author of QlikShare. Previous top 20 Global QlikView Community contributor. And I am certified, Scrum Master (PSM). Currently, pursuing masters in Data Science from the University of London.

I have been building Data platforms and BI applications since 2005. I had worked on many successful QlikView, QlikSense and SQL Server implementations, right from the inception through the implementation and deployment. My experience and skills range from application development and UI design to system administration. I can work autonomously and directly with business stakeholders at all levels to define requirements; then develop, document, test and deliver end to end projects within existing project management/delivery frameworks. 

I am certified QlikView Designer, Developer, Administrator and Scrum Master. Expertise in Clustering setup, data modelling, data analysis, ETL and data migration projects. I have experience in dealing with large datasets (billions of rows). Qlik specialist with many years experience on versions 8.5 to 12, and now Qlik Sense including Sense APIs. Created many extensions and published them on Qlik branch. Certified Designer, Developer, System Administrator and Qlik Sense Data Architect and known within Qlik as a subject-matter expert.

Technical Skills: 
Data Science: Python, Pandas, Numpy and D3.js
Business Intelligence: QlikView, QlikSense, SSRS, SSIS and PowerBI
Database: SQL Server and Oracle
Big Data: Apache Hive and Apache Pig
Web: HTML 5, CSS, JavaScript, JQuery, AngularJS and QlikSense API
Design: Photoshop, Illustrator and Coreldraw
Other: Advanced Excel, VBA, VB Script and Scrum Master

Experience in:
1. Investment Banking
2. Retail
3. Advertising
4. Media
5. Technology