Introduction
o What Is QlikView?
o About TheOverall Course
o QlikView Basics
Making Queries in QlikView
o Opening the document
o Basic QlikView terminology
o Selections
o Stepping back or forward in the list of
o selections
o Locking and unlocking selections
o Searching values
o Selection bookmarks
o Saving your work
o Checking your work
Handling Sheets & Sheet Objects
o Opening the document
o Sheets
o ogical connections between sheets
o Adding a sheet
o Moving a sheet
o Adding new sheet objects
o Saving, closing and exiting
List Boxes & Statistics Boxes
o Opening the document
o The list box
o The statistics box
o Saving, closing and exiting
Bar Charts & Pie Charts
o Introduction
o Opening the document
o Making selections in a chart
o Changing chart types using a fast type change
o icon
o Creating a bar chart using the Quick Chart
o Wizard
o Creating a bar chart using the full chart wizard
o Removing a chart
o Changing a few properties
o Cloning and detaching your chart
o Turning the bar chart into a pie chart
o Saving, closing and exiting
Pivot Tables & Straight Tables
o Opening the document
o Adding a dimension to a bar chart
o Turning a bar chart into a multidimensional o pivot table o Creating a straight table o Saving, closing and exiting
More Chart Types
o Opening the document
o Creating a line chart
o Adding an expression to a bar chart
o Turning the bar chart into a combo chart
o Turning the combo chart into a scatter chart
o Creating a scatter chart from scratch
o Creating a gauge chart
o Working with drill-down functionality
o Copying to Clipboard and printing
o Saving, closing and exiting
Multi Boxes, Table Boxes and Input
o Boxes
o Opening the document
o The multi box
o The table box
o Using an input box
o Saving, closing and exiting
Buttons, Text Objects And Line/Arrow
o Objects
o Opening the document
o The text object
o The line/arrow object
o The button
o Saving, closing and exiting
Sliders, Current Selection Objects and Bookmark Objects
o Opening the document
o The slider/calendar object (in slider mode)
o Creating a Current Selections box
o Creating a bookmark object
o Saving, closing and exiting
Document Properties, User Preferences & Reload
o Opening the document
o Setting Document Properties
o User Preferences
o Reloading data
o Saving, closing and exiting
o Checking your work
o What's next?
CREATING A DOCUMENT
o Introduction
Loading Data into QlikView
o Looking at a delimited text file
o Creating a new QlikView document
o Loading a text file into QlikView
o Saving, closing and exiting
Associating Data from Many Tables
o Associations
o Opening the document
o Loading and associating a second table
o Renaming fields
o Saving, closing and exiting
Concatenating Tables
o Opening the document
o Automatic concatenation
o Forced concatenation
o Saving, closing and exiting
The Table Structure
o Using the Table Viewer
o Labeling tables in the script
o Improving the layout
o Saving, closing and exiting
Layout Themes
o Creating a theme
o Applying a theme
o Saving, closing and exiting
Loading Additional Files
o Opening the document
o Loading a tab separated file without labels
o Loading a file via OLE DB
o Saving, closing and exiting
Linking External Information to a Document
o Opening the document
o Looking at an info table
o Loading the info table
o Viewing the linked information
o Embedding external info
o Displaying info in a text object
o Saving, closing and exiting
Advanced Features
o Introduction
More about Associations
o Creating a system sheet
o Using the system sheet
o Creating a system table
o Showing frequency in key fields
Load Inline
o Adding a record with load inline
o Adding a table with load inline
Field Groups & Cyclic Display
o Field groups
o Cyclic display of expressions
Loading Cross Tables
o Loading a cross table
o Loading a cross table with more than one
o regular column
And-Mode in List Box
o Making an and-selection
o Making a not selection
o Characteristics of the and table
Number Formats
o Handling of numeric data
o Interpretation of numeric data
o Formatting of data
Security
o Sections in the Script
o Access levels
o Security fields
o Loading security tables
o Using the Security pages
o Opening a document with access restriction