Training Options

QlikView Training – End Users

Basic QlikView training for normal users. This course is often tailor-made to the client's unique QlikView application(s) and is normally held on site at customer's premises. Covers things like making selections, creation of bookmarks, printing and export. The documentation is based on your applications plus some standard examples.

This course covers all the needs of a QlikView end user.

  • Open QlikView documents
  • Refresh data
  • Introduction of QlikView objects
  • How to navigate through your application
  • List Box
  • Multi Box
  • Charts
  • Current selections (filters)
  • Selecting Data using filters
  • Search for data
  • Locking selections
  • Hierarchies and cycle groups
  • Sort
  • Bookmarks
  • Exporting data to excel
  • Printing of reports
  • Exercises

QlikView Training – Power User

This classroom course is intended for developers and "power users" in QlikView. To follow the course you need little or no prior experience with QlikView. The primary focus of the course is the toolbox of various sheet objects that are used for building the layout/user interface. We will begin by learning the basic functionality in a sample layout and then gradually start modifying and adding to it.

The course is intended as a solid introduction to QlikView, but those who intend to take the Developer, i.e. the general course for developers in QlikView, at a later occasion, may also benefit from it.

When you have finished the course, you should be proficient in the following areas:

  • How to use QlikView for searching information and generating reports.
  • How to design your own QlikView documents, complete with list boxes, tables, charts and any other sheet objects.
  • How to copy layout styles within and between documents.

QlikView Training – Developer

This three-day classroom course is recommended for power users, developers and IT staff that will be developing new or enhancing or maintaining existing QlikView applications. The session covers scripting, data source integration, and advanced GUI development. This module requires a basic working knowledge of databases and SQL.

Schedule

Course times daily: 
9:00am to 5:00pm.

Content daily outline

Day 1

  • QlikView Introduction
  • Versions
  • Installation
  • Project Plan
  • Data Sources
  • Star Schema
  • Smart Structure
  • User Settings
  • Document Settings
  • Script Editor
  • Syntax
  • SQL vs QlikView
  • Preceding Load
  • Connect
  • Linking Tables
  • How to "drive" QlikView
  • Correct interpretation of QlikView
  • Selecting data
  • Clearing selections
  • Search
  • Bookmarks
  • Bookmark Objects
  • Print
  • Export Data
  • Debugger
  • Logfiles
  • Dimensions
  • Create System Tab
  • System Fields
  • Synthetic Keys – how to avoid
  • Loops
  • Autonumber function
  • Loading data from Excel files
  • Loading data from XML files
  • Key Fields

Day 2

  • Mapping loads
  • Cleaning up table structure
  • Listbox Expression
  • Extended listbox functionality
  • QVD Exports
  • Front End best practices
  • Table Box
  • Charts
  • Calendar
  • Transformation of data using QlikView functions
  • Variables
  • Container Objects
  • Fiscal periods
  • Resident loads
  • Where function
  • Different ways of joining tables
  • Inline loading
  • Autogenerate

Day 3

  • Buttons
  • Macros
  • Loading Budgets
  • Cross tables
  • Input fields
  • Security
  • Sorting in charts
  • Selecting in charts
  • Cycle Groups
  • Drop down select in charts
  • Pivot tables
  • Reports
  • Set Analysis
  • Trouble-Shooting
  • Advanced scripting

QlikView Training – Customised

Customised training is offered to meet the needs of customers whose requirements may not fall into one of the 3 other main courses we provide.

This could be refresher training for power users who need an update or even an advanced developer session for those who have been working with QlikView for a while and are ready to learn more complex functionality.

Another example of customised training would be learning to administrate QlikView Server, including installation of all components and understanding and maintaining the QlikView Server in your environment.

The content is really up to you - our customised training service gives you the ability to have covered just what you need to know in a time-efficient way.