QlikView Training
QlikView Training makes you an expert in Business Analytics using QlikView tool and learn all that is required to create real world Analytical Visualizations with the QlikView.
QlikView Training Curriculum
Introduction
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
QlikView Basics
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
Handling Sheets And Sheet Objects In QlikView
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
Loading Data Into 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
List Boxes And Statistics Boxes
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
Bar Charts And Pie Charts 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
QlikView Pivot Tables And Straight Tables
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
More Chart Types In QlikView
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
Working With Multi Boxes,Table Boxes And Input Boxes
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
Explore Buttons,Text Objects And Line/Arrow Objects
Explore Sliders, Current Selection Objects And Bookmarks
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
QlikView Document Properties, User Preferences And Reload
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
Associating Data From Many Tables And Concatenating Tables
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
Working With QlikView Tables And QlikView Layout Themes
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
Loading Additional Files
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
Linking External Information To A QlikView Document
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
More About Associations
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
Exploring QlikView Load Inline, Field Groups And Cyclic Display
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
Loading Cross Tables
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
And-Mode In A List Box
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
Explore Number Formats
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
Working With Security Features
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.