Qlik Community

QlikView Documents

Documents for QlikView related information.

QlikView 11 Developer Tutorial

Not applicable

QlikView 11 Developer Tutorial

Build a complete QlikView 11 application step-by-step: a QlikView 11 tutorial for developers


This QlikView 11 tutorial is for developers with at least some programming experience in any computer language. Over the course of the tutorial, you will learn how to:

  • read data from multiple sources (data from websites, data from Excel, data from databases),
  • cleanse data,
  • create a fully featured data model without circular references,
  • display data in maps, charts, and text across multiple sheets.

This QlikView tutorial will teach you a range of methods that QlikView developers use to create fully featured professional quality applications.

You can follow the tutorial step-by-step, or you can jump in and just view part of it. The steps are designed to be independent of one another and also to work as short briefings on developer topics (e.g. connecting to a database with an ODBC connector).


For each step of the tutorial, we have made available a video, the video script, the QlikView file, and the data files (where appropriate). You can download all of these items free of charge by clicking on the download links.

Here's what's in the tutorial:

Data from websitesData from spreadsheetsDisplaying data

Clean data

Loading partial data

Cleansing dirty data

Spreadsheets from websites

Simple data

Rearranging data with crosstables

Population pyramid

Displaying key parameters

Extension Objects

Drop-down menus

Data from databasesData modelsConclusions

Getting and preparing databases

Adding ODBC connections in Windows

Adding ODBC data in QlikView

Field names that change

Making new fields

Linking different tables - keys

Removing circular references

TRACE

Putting it all together

What's next?

Education and training

QlikCommunity

This page is part 1 of the tutorial.

Going beyond this tutorial, the resources on our education and training pages and on QlikCommunity will be helpful to you.

Get the script for the videos

Sometimes, videos aren't enough. If English isn't your first language or you have hearing issues, it can be hard to follow what's said during videos. To help you out, we've written out the full script for the videos. You can download the full video script.

Overview

Here we provide an overview of the tutorial and explain how to get the project files up and running.

Watch the video at full resolution


Download and use the files


The files for this part of the tutorial are complete - but they are large. They include all of the database files which will consume several GB on your hard drive and may take a while to download, depending on your internet connection.

Here are the files to download:

How to use the downloaded files:

  1. Unzip the QVW file to a folder.
  2. Unzip the image files to an Images sub folder (under the QVW folder).
  3. Unzip the census files to a Census sub folder (under the QVW folder)
  4. Unzip the SVG files to a svgMap folder (under the QVW folder)
  5. Unzip the database files to FARSDBF folder (under the QVW folder)
  6. Unzip the QVD files to a QVD folder (under the QVW folder).

When you're done, your folder structure should look like this:

2014-11-05 15_49_07-FARS-i.png

To reload the data, you may need to edit the load script to point the script to the correct file locations. The script uses file locations in several places, but they are clearly marked. You'll also need to connect an ODBC database to the DBF files. How to do this is covered in the 'data from databases' section.

What's next?

Education and training

A short tutorial can only cover a few topics. To fully exploit the full power of the QlikView platform, you should consider taking a QlikView course.

We offer a range of courses for different needs, ranging from courses for UI designers through to courses for developers and system administrators.Courses are available in-person and virtually. We even offer several courses you can take at no charge.

To find out more about our training courses, visit this web page: http://www.qlikview.com/us/services/training

QlikCommunity

Very few problems developers have are unique. If you have a QlikView problem, there's a good chance someone else has faced the same problem and solved it. QlikCommunity brings together the global QlikView community into an open forum where community members ask and solve questions, share advice,and provide example applications. Joining the community is free.

To join the community, sign up here: http://community.qlikview.com/welcome

Tags (2)
Comments
michael_gardner
Contributor III

Great Stuff

Not applicable

Hi Michael,

This is complete now.

Mike

Not applicable

Very Good and Helpful Tutorial Michael, I would like to understand from the begining and clearly the Loop "FOR", do you have a video for this Loop? I have been struggling on this to create QVD Files per month.

Regards!

Not applicable

Hi Javier,

Unfortunately, I don't have a video on the for loop, but the completed project uses a lot of for loops. I suggest you download the QVW file (from this page QlikView 11 Developer Tutorial) and look at the code for help.

Mike

Not applicable

Can you please post the URLs for the websites used? 

This is excellent, by the way!  Thanks!

Not applicable

Hi David,

Unfortunately, some of the URLs I use are quite long and just quoting the website along wouldn’t help either as the data can sometimes be very hard to find.

All of the URLs are in the load script files for the examples, so you can get them quite easily from there.

Mike

Not applicable

Great job. Thanks for posting.

joaquinlr
Valued Contributor II

Hi Michael Woodward

Fantastic, I will use it a lot.

Thank you very much

Joaquín

Not applicable

Hi, give me a error in documents like http://community.qlik.com/docs/DOC-7474

Access Denied.

Can help?

Thanks!

joaquinlr
Valued Contributor II

HI otavioremedio:

I've just read this doc, have you logged in at the ccommunity ?

Joaquín

Version history
Revision #:
1 of 1
Last update:
‎11-04-2014 04:05 PM
Updated by: