Mastering QlikView Set Analysis
4.5 (102 ratings)
458 students enrolled
Wishlisted Wishlist

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

# Mastering QlikView Set Analysis

Deep Dive Set Analysis Course for QlikView and Qlik Sense Developers
4.5 (102 ratings)
458 students enrolled
Last updated 1/2017
English
Current price: \$29 Original price: \$195 Discount: 85% off
30-Day Money-Back Guarantee
Includes:
• 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
Requirements
• QlikView development
Description

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
• QlikView designers
Curriculum For This Course
66 Lectures
05:37:41
+
Getting Started
3 Lectures 13:30
Preview 02:54

03:54

1.3: Associative Model
06:42
+
Set Analysis Fundementals
10 Lectures 01:08:59
Preview 07:53

2.2: Visual Representation of Set Analysis
08:24

2.3: Set Theory Refresher
05:20

2.4: Conceptual Aside - Set Identifier
12:49

Set Identifier
3 questions

2.5: Conceptual Aside - Set Operator
09:13

Set Operator
2 questions

2.6 - Challenge - Set Identifier (Introduction)
01:07

2.6: Challenge - Set Identifier
00:18

2.7: Solution - Set Identifier
08:20

2.8: Challenge - Set Operator
00:23

2.9: Solution - Set Operator
15:11
+
Set Modifier Deep Dive
21 Lectures 01:51:55
3.1: Conceptual Aside - Set Modifier
12:32

3.2: Challenge - Set Modifier
00:43

3.3: Solution - Set Modifier
08:44

Set Modifier
2 questions

3.4: Conceptual Aside - Two or More Set Modifiers
03:13

3.5: Challenge - Two or More Set Modifiers
00:10

3.6: Solution - Two or More Set Modifiers Part I
04:04

3.6: Solution - Two or More Set Modifiers Part II
08:15

Two or More Set Modifiers
2 questions

3.7: Challenge - Set Modifiers with Wild Card
00:18

3.8: Solution - Set Modifiers with Wild Card
05:53

3.9: Conceptual Aside - Set Modifiers with Range
04:01

3.10: Challenge - Set Modifiers with Range
00:29

3.11: Solution - Set Modifiers with Range
13:11

Set Modifier with Range
2 questions

3.12: Conceptual Aside - Nested Expressions
07:51

3.13: Challenge - Nested Expressions
00:27

3.14: Solution - Nested Expressions
11:15

Lesson 3.14: Challenge 11 Revised solution
05:21

Nested Expessions
2 questions

3.15: Challenge - Advanced Set Modifier
00:32

3.16: Solution - Advanced Set Modifier
11:15

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

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

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

Element Functions - P() and E()
2 questions
+
15 Lectures 01:06:06
4.1: Conceptual Aside - Dollar Sign Expansion
07:24

Dollar Sign Expansion
2 questions

4.2: Conceptual Aside - Double Dollar Sign Expansion
04:42

4.3: Conceptual Aside - Parameterized Dollar Sign Expansion
04:08

Parameterized Dollar Sign Expansion
2 questions

4.4: Conceptual Aside - Set Exclusions
06:43

Set Exclusion
2 questions

4.5: Conceptual Aside - Dealing with NULL values
07:12

Dealing with NULL values
2 questions

4.6: Conceptual Aside - Set Analysis with Alternate States
06:20

Set Analysis with Alternate States
2 questions

4.7: Conceptual Aside - Compare two fields
04:36

4.8: Conceptual Aside - Interesting operators
08:10

Interesting Operators
2 questions

4.9: Conceptual Aside - Set Modifier with an Expression
04:37

Set Modifier with an Expression
2 questions

Lesson 4.10: Challenge - Set Analysis with Alternate States
01:04

Lesson 4.11: Solution - Set Analysis with Alternate States
04:39

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
00:09

Lesson 4.13: Solution - Exclusion operators
03:04

Lesson 4.14: Challenge - Compare two fields
00:10

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

Aggr() Function
2 questions

5.2: Challenge I - Aggr()
00:11

5.2: Challenge II - Aggr()
00:11

5.2: Challenge III - Aggr()
00:08

5.3: Solution I - Aggr()
03:48

5.3: Solution II - Aggr()
08:37

5.3: Solution III - Aggr()
05:12

5.4: Conceptual Aside - Concat()
06:51

Concat() Function
3 questions

5.5: Challenge - Concat()
00:34

5.6: Solution - Concat()
06:54

5.7: Conceptual Aside: FirstSortedValue()
12:15

5.8: Challenge 1 - FirstSortedValue()
00:10

5.8: Solution 1 - FirstSortedValue()
11:00

5.9: Challenge 2 - FirstSortedValue()
00:12

5.9: Solution 2 - FirstSortedValue()
11:13

Summary
00:49
+
Bonus
1 Lecture 00:03
Mastering QlikView Set Analysis Guide: Syntax and Examples
00:03
 4.5 Average rating 266 Reviews 960 Students 3 Courses
Teach..Learn..Inspire

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.

 4.1 Average rating 1,467 Reviews 6,049 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!

 4.5 Average rating 266 Reviews 960 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