Qlikview Online Training

Welcome

Qlikview Onine Training

QlikView Online Training Course Content


Introduction


What Is QlikView?

About TheOverall Course

QlikView Basics


Making Queries in QlikView


Opening the document

Basic QlikView terminology

Selections

Stepping back or forward in the list of

selections

Locking and unlocking selections

Searching values

Selection bookmarks

Saving your work

Checking your work


Handling Sheets & Sheet Objects


Opening the document

Sheets

Logical connections between sheets

Adding a sheet

Moving a sheet

Adding new sheet objects

Saving, closing and exiting


List Boxes & Statistics Boxes


Opening the document

The list box

The statistics box

Saving, closing and exiting


Bar Charts & Pie Charts


Introduction

Opening the document

Making selections in a chart

Changing chart types using a fast type change

icon

Creating a bar chart using the Quick Chart

Wizard

Creating a bar chart using the full chart wizard

Removing a chart

Changing a few properties

Cloning and detaching your chart

Turning the bar chart into a pie chart

Saving, closing and exiting


Pivot Tables & Straight Tables


Opening the document

Adding a dimension to a bar chart

Turning a bar chart into a multidimensional

pivot table

Creating a straight table

Saving, closing and exiting


More Chart Types


Opening the document

Creating a line chart

Adding an expression to a bar chart

Turning the bar chart into a combo chart

Turning the combo chart into a scatter chart

Creating a scatter chart from scratch

Creating a gauge chart

Working with drill-down functionality

Copying to Clipboard and printing

Saving, closing and exiting


Multi Boxes, Table Boxes and Input

Boxes


Opening the document

The multi box

The table box

Using an input box

Saving, closing and exiting


Buttons, Text Objects And Line/Arrow

Objects


Opening the document

The text object

The line/arrow object

The button

Saving, closing and exiting


Sliders, Current Selection Objects and

Bookmark Objects


Opening the document

The slider/calendar object (in slider mode)

Creating a Current Selections box

Creating a bookmark object

Saving, closing and exiting


Document Properties, User

Preferences & Reload


Opening the document

Setting Document Properties

User Preferences

Reloading data

Saving, closing and exiting

Checking your work

What's next?





CREATING A DOCUMENT


Introduction


Loading Data into QlikView


Looking at a delimited text file

Creating a new QlikView document

Loading a text file into QlikView

Saving, closing and exiting


Associating Data from Many Tables


Associations

Opening the document

Loading and associating a second table

Renaming fields

Saving, closing and exiting


Concatenating Tables


Opening the document

Automatic concatenation

Forced concatenation

Saving, closing and exiting


The Table Structure


Using the Table Viewer

Labeling tables in the script

Improving the layout

Saving, closing and exiting


Layout Themes


Creating a theme

Applying a theme

Saving, closing and exiting


Loading Additional Files


Opening the document

Loading a tab separated file without labels

Loading a file via OLE DB

Saving, closing and exiting


Linking External Information to a

Document


Opening the document

Looking at an info table

Loading the info table

Viewing the linked information

Embedding external info

Displaying info in a text object

Saving, closing and exiting


Advanced Features


Introduction


More about Associations


Creating a system sheet

Using the system sheet

Creating a system table

Showing frequency in key fields


Load Inline


Adding a record with load inline

Adding a table with load inline


Field Groups & Cyclic Display


Field groups

Cyclic display of expressions


Loading Cross Tables


Loading a cross table

Loading a cross table with more than one

regular column


And-Mode in List Box


Making an and-selection

Making a not selection

Characteristics of the and table


Number Formats


Handling of numeric data

Interpretation of numeric data

Formatting of data


Security


Sections in the Script

Access levels

Security fields

Loading security tables

Using the Security pages

Opening a document with access restriction