Name: Mastering QlikView Set Analysis
Rating: 4.6 (799 reviews)

Hier kannst du dein Wissen und Können an Millionen von Teilnehmer:innen in aller Welt weitergeben und damit richtig Geld verdienen!

Weitere Infos

Dein Einkaufswagen ist leer.

Weiter einkaufen

Anmelden

Registrieren

Erstellt vonVertechs .IO, Shilpan Patel, Deepak Vadithala (DV), Satya Ghantasala

Zuletzt aktualisiert 1/2017

Englisch

Das wirst du lernen

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

Kursinhalt

6 Abschnitte • 66 Lektionen • 5 Std. 37 Min. Gesamtdauer

1.1: Course Introduction2:54
1.2: Setup - Loading QVD Files3:54
1.3: Associative Model6:42

2.1: What is Set Analysis and Why use it?7:53
2.2: Visual Representation of Set Analysis8:24
2.3: Set Theory Refresher5:20
2.4: Conceptual Aside - Set Identifier12:49
Set Identifier
2.5: Conceptual Aside - Set Operator9:13
Set Operator
2.6 - Challenge - Set Identifier (Introduction)1:07
2.6: Challenge - Set Identifier0:17
2.7: Solution - Set Identifier8:20
2.8: Challenge - Set Operator0:21
2.9: Solution - Set Operator15:11

3.1: Conceptual Aside - Set Modifier12:32
3.2: Challenge - Set Modifier0:43
3.3: Solution - Set Modifier8:44
Set Modifier
3.4: Conceptual Aside - Two or More Set Modifiers3:13
3.5: Challenge - Two or More Set Modifiers0:10
3.6: Solution - Two or More Set Modifiers Part I4:04
3.6: Solution - Two or More Set Modifiers Part II8:15
Two or More Set Modifiers
3.7: Challenge - Set Modifiers with Wild Card0:16
3.8: Solution - Set Modifiers with Wild Card5:53
3.9: Conceptual Aside - Set Modifiers with Range4:01
3.10: Challenge - Set Modifiers with Range0:27
3.11: Solution - Set Modifiers with Range13:11
Set Modifier with Range
3.12: Conceptual Aside - Nested Expressions7:51
3.13: Challenge - Nested Expressions0:24
3.14: Solution - Nested Expressions11:15
Lesson 3.14: Challenge 11 Revised solution5:21
Nested Expessions
3.15: Challenge - Advanced Set Modifier0:29
3.16: Solution - Advanced Set Modifier11:15
3.17: Conceptual Aside - Element Functions P() and E()5:03
3.18: Challenge - Element Functions P() and E()0:17
3.19: Solution - Element Functions P() and E()8:17
Element Functions - P() and E()

4.1: Conceptual Aside - Dollar Sign Expansion7:24
Dollar Sign Expansion
4.2: Conceptual Aside - Double Dollar Sign Expansion4:42
4.3: Conceptual Aside - Parameterized Dollar Sign Expansion4:08
Parameterized Dollar Sign Expansion
4.4: Conceptual Aside - Set Exclusions6:43
Set Exclusion
4.5: Conceptual Aside - Dealing with NULL values7:12
Dealing with NULL values
4.6: Conceptual Aside - Set Analysis with Alternate States6:20
Set Analysis with Alternate States
4.7: Conceptual Aside - Compare two fields4:36
4.8: Conceptual Aside - Interesting operators8:10
Interesting Operators
4.9: Conceptual Aside - Set Modifier with an Expression4:37
Set Modifier with an Expression
Lesson 4.10: Challenge - Set Analysis with Alternate States1:04
Lesson 4.11: Solution - Set Analysis with Alternate States4:39
Lesson 4.12: Challenge - Exclusion operators0:09
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.13: Solution - Exclusion operators3:04
Lesson 4.14: Challenge - Compare two fields0:09
Lesson 4.15: Solution - Compare two fields3:08

5.1: Conceptual Aside - Aggr()9:17
Aggr() Function
5.2: Challenge I - Aggr()0:10
5.2: Challenge II - Aggr()0:10
5.2: Challenge III - Aggr()0:08
5.3: Solution I - Aggr()3:48
5.3: Solution II - Aggr()8:37
5.3: Solution III - Aggr()5:12
5.4: Conceptual Aside - Concat()6:51
Concat() Function
5.5: Challenge - Concat()0:32
5.6: Solution - Concat()6:54
5.7: Conceptual Aside: FirstSortedValue()12:15
5.8: Challenge 1 - FirstSortedValue()0:09
5.8: Solution 1 - FirstSortedValue()11:00
5.9: Challenge 2 - FirstSortedValue()0:12
5.9: Solution 2 - FirstSortedValue()11:13
Summary0:46

Anforderungen

QlikView development

Beschreibung

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.

Für wen eignet sich dieser Kurs:

QlikView developers
Business Analysts
QlikView designers

Das wirst du lernen

Zugehörige Themengebiete entdecken

Kursinhalt

Getting Started3 Lektionen • 14 Min.

Set Analysis Fundementals10 Lektionen • 1 Std. 9 Min.

Set Modifier Deep Dive21 Lektionen • 1 Std. 52 Min.

Advanced Set Analysis15 Lektionen • 1 Std. 6 Min.

Useful Set Functions16 Lektionen • 1 Std. 17 Min.

Bonus1 Lektionen • 1 Min.

Anforderungen

Beschreibung

Für wen eignet sich dieser Kurs: