Become QlikView Developer from Scratch

Learn how to become an awesome QlikView developer and earn over USD $100,000 a year without any prior experience.
4.1 (540 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.
• 3,355 students enrolled Bestselling in QlikView
Take This Course
  • Lectures 49
  • Length 8 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2015 English

Course Description

Course updated on May 30, 2016.

Hi there! Since you've stumbled upon this course, you are likely looking for QlikView training to become an awesome QlikView developer. That's fabulous. But, if you are still wondering if this course is right for you or not, let not your heart be troubled.

Let me breakdown reasons for you to become a QlikView developer.

  1. Have you been asked to create a QlikView application at your work since your company just invested in QlikView as a business discovery tool?
  2. Are you looking to quickly learn QlikView scripting to transform data from various sources?
  3. Did you create a QlikView application without formal training but feel that you have not unleashed power of QlikView's unique ETL capability?
  4. Do you enjoy building data models that can help companies gain insight and help executives make fact based decisions?
  5. Are you a Business Intelligence professional with experience with Cognos or OBIEE and want to change career as most QlikView developers make six-figure income?

If you answered 'yes' to any of these questions, then this course is for you!

QlikView is growing rapidly. With over 30,000 customers, demand for skilled QlikView developers l is higher than ever before!

QlikView is the only in-memory tool with ETL(Extract, transform, load) engine to transform data from various data sources.

This course will make you an awesome QlikView developer. You will be able to extract data from various sources and transform data based on the business rules to create a data model that business analysts can use to create Presentation layer.

Course starts with basics and builds on gradually. Each session starts with a conceptual overview followed by hands-on examples to reinforce concepts. Each session also contains a quiz to test level of your knowledge.

I also am committed to keep improving and enhancing course content in the future and you will have lifetime access to this course.

Enroll in this course now and start making six-figure income by becoming a QlikView developer. Welcome aboard!

What are the requirements?

  • Download Free QlikView desktop from
  • Understand basics of SQL

What am I going to get from this course?

  • You will be able to start building QlikView data models after completing this course.

Who is the target audience?

  • Are you interested in learning how to connect to various data sources, transform data and create a QlikView data model for data visualization and business discovery? Are you interested in making six-figure income by learning QliKView developer? If you answered YES then this is the right course for you! Welcome to the Course!
  • This course will teach you all the concepts with hands-on tutorials to make you an awesome QliKView developer. No prior programming exprience is needed other than basic understanding of SQL.
  • You will learn concept first before the hands-on session to make it easier for your to master each QliKView scripting concept. In addition, eachh section has a quiz to gauge your level of knowledge

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Introduction to QlikView

Introduction to QlikView as a Business Discovery Platform

Overview of QlikView Personal Edition, QlikView Desktop, QlikVew Server and QlikView Publisher

Course Syllabus
QlikView Overview
Introduction to Relational Database
Data Files
Dimensions and Measures
4 questions

This Quiz will gauge your knowledge about basics of QlikView architecture, relational databases and dimension data model.

Section 2: Introduction to Scripting
Install QlikView Desktop
Introduction to Scripting
Connect to the Database

Conceptual overview of script syntax

Load Fact Tables
Introduction to Scripting
3 questions
Section 3: Data Modeling Basics
Understanding data model
Synthetic Keys
Remove Synthetic Key from the Data Model
Data load from an Excel file
Load a table from an Excel file
Load data from XML file
How to resolve circular loops and synthetic keys
Data Modeling Basics
3 questions
Section 4: Generating Data in the Script
How to generate data in the script
Generating data in the script using Resident load
Master Calendar
Master Calendar Script
Improved Master Calendar Script
Mapping tables
Add Mapping tables and Preceding load to the script
Generating data in the script
5 questions
Section 5: Data Model Optimization
Joins vs Concatenate
Join or Concatenate tables
Optimize data model
Create star schema
Data Model Optimization
2 questions
Section 6: Data Model Challenges
Cross tables
Load data from Cross table
Link tables
Create a Link table
Data Model Challenges
2 questions
Section 7: Scripting Considerations
Slowly Changing Dimensions
IntervalMatch function
Introduction to Set Analysis

This is a hands-on side example to go over basics of Set Analysis from my blog(

Power of Set Analysis Part I
Power of Set Analysis Part II
AGGR function
QlikView Data Files(QVD)
Load data from QVD
Add metadata
Scripting Considerations
4 questions
Section 8: Security
Introduction to document security
Add Section Access
4 questions
Section 9: QlikView Scripting: Tips and Tricks
QlikView Script Syntax: 3 Pitfalls to Avoid
QlikView Substring Functions
QlikView Set analysis Cheat Sheet

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Shilpan Patel, Certified QlikView Developer and Designer

Greetings! I am a certified QlikView developer and designer /Qlik Sense Data Architect 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!

Ready to start learning?
Take This Course