1. Introduction

• What is QlikView?
• QlikView Basics
• Document

2. Query editor: simple data load from file

3. QV Objects

4. Making Queries in a QlikView Document

• Basic QlikView terminology / colors
• Associative selections
• Stepping back or forward in the list of selections
• Locking and unlocking selections
• Searching values
• Selection bookmarks

5. Script Editor Basics: Loading Data into QlikView

• Loading a text file into QlikView
• Loading an Excel file into QlikView
• Loading a qvd file into QlikView

6. Handling Sheets & Sheet Objects

• Sheets
• Logical connections between sheets
• Adding, Moving, Copying a sheet
• Adding new sheet objects
• Sheet Design fundamentals
• Object Properties

7. List Boxes & Statistics Boxes

• The list box
• The statistics box

8. Aggregations – Charts: Bar Charts & Pie Charts

• Introduction
• Making selections in a chart
• Changing chart types using a fast type change icon
• Creating a bar chart using the Wizard
• Removing a chart
• Changing a few properties
• Cloning and detaching your chart
• Turning the bar chart into a pie chart

9. Pivot Tables & Straight Tables

• Adding a dimension to a bar chart
• Turning a bar chart into a multidimensional pivot table
• Creating a straight table

10. More Chart Types: Line, Combo, Gauge

• 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

11. Variables

• Defining a variable in the script.
• Let / Set
• Managing variables in the Variable Manager
• Assigning a value to a variable
• Evaluating a variable (Dollar expansion)

12. Multi Boxes, Table Boxes and Input Boxes

• The multi box
• The table box
• Using an input box

13, Buttons, Text Objects and Line/Arrow Objects

• The text object
• The line/arrow object
• The button object

14. Sliders, Current Selection Objects and Bookmark Objects

• The slider/calendar object (in slider mode)
• Creating a Current Selections box
• Creating a bookmark object

15. Document Properties, User Preferences & Reload

• Setting Document Properties
• User Preferences
• Reloading data

16. Object Properties

• Conditional showing objects and expression fields
• Using the Expression editor