QlikView Training

The QlikView training introduction module is presented to let you know that it is a flexible business intelligence platform, for turning data into knowledge.

What are QlikView Conventions
QlikView General conventions
Keyboard conventions and Regional settings

The basic Qlikview online training module, aims at familiarizing the QlikView environment to you, showing how to start off with QlikView, commonly used terminology includes server, bookmarks etc….

Starting QlikView
The QlikView Start Page
Opening a document
Saving a document in QlikView
Basic QlikView terminology
Closing a document in QlikView
Help Using Documents on a QlikView Server
Selections Stepping back or forward in the list of selections
Locking and unlocking selections
Searching values in Selection bookmarks in QlikView
Saving your work and Checking your work

After having a good understanding of the QlikView basics, lets move on to the next level of knowing all about ‘sheets’.

Introduction to QlikView Sheets
Logical connections between QlikView sheets
Adding a QlikView sheet
Moving a QlikView sheet
Adding new sheet objects
Saving, closing and exiting in QlikView

By the end of this module, you will be able to load data from different data sources, also know-how to place restrictions while loading data into QlikView.

Looking at a delimited text file in QlikView, Creating a new QlikView document
Loading a text file into QlikView

This module introduces the list box and the statistics box in QlikView, how to add, copy, move, size and remove a list box, you’ll also modify its appearance and its way of displaying data.

Opening the QlikView document
Exploring the list box
Exploring statistics box in QlikView

This module will start by giving you a general introduction of working with charts in QlikView; starting with creating a simple bar chart and finally turn it into a pie chart.

Introduction of Making selections in a chart, Changing chart types in QlikView 
Creating a bar chart using the Quick Chart Wizard in QlikView
Creating a bar chart using the full chart wizard in QlikView
Removing a chart from QlikView
Changing a few QlikView chart properties
Cloning and detaching your chart
Turning the bar chart into a pie chart

In this module, after adding a dimensions to an existing bar chart, you will now learn how to turn it into a pivot table and subsequently create a straight table in QlikView containing the same information.

Adding a dimension to bar chart in QlikView, Creating a straight table

This module introduces further more QlikView chart types, like line chart, combo chart, scatter chart, etc…

Creating a line chart
Adding an expression to a bar chart in QlikView
Turning the bar chart into a combo chart
Turning the combo chart into a scatter chart
Creating a scatter chart from scratch in QlikView
Creating a gauge chart in QlikView
Working with drill-down functionality in QlikView
Copying to Clipboard and printing

By end of this module, you will be able to show data in a very compact way in QlikView, also how input boxes can be used for interactive input of data.

QlikView multi box
QlikView table box using an input box

Buttons are used for carrying out commands in an easy way, or for exporting data. Learn much more about buttons, text object, line/ arrow objects in this module of QlikView

The QlikView text object
The line/arrow object
The button in QlikView

Learn the three additional types of sheet objects which can be used to make QlikView documents more user friendly, in this module.

The slider/calendar object (in slider mode)
Creating a Current Selections box in QlikView
Creating a bookmark object in QlikView
Saving, closing and exiting

At the end of this module, you will learn how to reload data from the data sources that contain the data shown in your QlikView document.

Creating a  QlikView Document
Setting QlikView Document
Properties,User Preferences & Reloading data into QlikView
Checking your work

In this module, we will train you how to associate different tables that have fields in common or alternatively, even merge tables through concatenation.

QlikView Associations
Loading and associating a second table
Renaming fields in QlikView
Automatic concatenation in QlikView
Forced concatenation in QlikView

This module will acquaint you to the table structure, how to assign suitable table names while loading them and how to “extract” layout settings from an existing QlikView document to a theme file, and then apply the same settings to the new document.

Using the  QlikView Table Viewer
Labelling tables in the script
Improving the QlikView layout
Creating a theme in QlikView
Applying a theme in QlikView

In this module, you will learn how to load a tab separated text file without field names. Moreover, you will get an introduction to loading files via the ODBC interface.

Loading a tab separated file without labels, Loading a file via OLE DB

Besides associating and concatenating tables in QlikView that contain data, it is also possible to link information to field values in the data, we'll see how to do that in this module.

Looking at an info table
Loading the info table in QlikView
Viewing the linked information
Embedding external info into QlikView
Displaying info in a text object

We’ll learn how system sheet is created in QlikView and its importance in this module.

Creating a QlikView system sheet
Using the QlikView system sheet
Creating a system table
Showing frequency in key fields

Using Load Inline, you can add data directly by entering it into QlikView, also the importance of using Field groups and cyclic display will be explained.

Adding a record with Load Inline
Adding a table with Load Inline
Field groups in QlikView
Cyclic display of expressions in QlikView

The procedure of loading cross tables, featuring a matrix of values between two orthogonal lists of header data will be demonstrated in this module of QlikView

Loading a cross table into QlikView
Loading a cross table with more than one regular column into QlikView

This module features a list box set to 'and-mode', which you will use for regular selections as well as for not-selections.

Making an 'and-selection' in QlikView
Making a 'not selection' in QlikView
Characteristics of the 'and table' in QlikView 

This module deals with the basics of number interpretation and number formatting.

Handling and Interpretation of numeric data in QlikView
Formatting of data in QlikView

It is important that information is distributed only to those who have rights to see it. This module  refers to  security settings in QlikView that are built in the script of the document.

Sections in the Script
QlikView Access levels
QlikView Security fields
Loading security tables in QlikView
Using the Security pages in QlikView
Opening a QlikView document with access restriction

Mindmajix offers advanced QlikView interview questions and answers along with QlikView resume samples. Take a free sample practice test before appearing in the certification to improve your chances of scoring high.