Tutorial
Version 8 for Microsoft Windows®
Second Edition, Lund, Sweden, November 2007
Authored by QlikTech International AB /KHN/JNN/MSJ/JHS
Tutorial.book Page 1 Friday, November 16, 2007 3:27 PM
Copyright © 1994-2007 QlikTech International AB, Sweden.
Under international copyright laws, neither the documentation nor the software may
be copied, photocopied, reproduced, translated or reduced to any electronic medium
or machine-readable form, in whole or in part, without the prior written permission of
QlikTech International AB, except in the manner described in the software agree-
ment.
Qlik
®Tech and Qlik®View are registered trademarks of QlikTech International AB.
Microsoft, MS-DOS, Windows, Windows NT, Windows 2000, Windows 2003, Win-
dows XP, SQL Server, FoxPro, Excel, Access and MS Query are trademarks of
Microsoft Corporation.
IBM, AS/400 and PowerPC are trademarks of International Business Machines Cor-
poration.
Borland, Paradox and dBASE are trademarks of Borland International.
ORACLE and SQL*Net are trademarks of Oracle Corporation.
MacOS is a trademark of Apple Corporation.
Tutorial.book Page 2 Friday, November 16, 2007 3:27 PM
CONTENT
3
INTRODUCTION
WHAT IS QLIKVIEW? ................................................................ 11
Flavors of QlikView ....................................................................................11
ABOUT THE TUTORIAL .............................................................. 13
C
ONVENTIONS .......................................................................... 15
General conventions ....................................................................................15
Mouse conventions ......................................................................................15
Keyboard conventions .................................................................................16
Regional settings .........................................................................................16
BASICS .................................................................................... 17
Starting QlikView ........................................................................................17
The start page ..............................................................................................17
Opening an existing file ..............................................................................17
Saving a document ......................................................................................18
Closing a document .....................................................................................18
QlikView Help ............................................................................................18
Using Documents on a QlikView Server ....................................................18
WORKING WITH QLIKVIEW
INTRODUCTION ......................................................................... 23
LESSON 1.MAKING QUERIES IN QLIKVIEW ................................... 25
Opening the document .................................................................................25
Basic QlikView terminology .......................................................................26
Selections .....................................................................................................26
Text searches and numeric searches ............................................................30
Stepping back or forward in the list of selections .......................................31
Locking and unlocking selections ...............................................................31
Selection bookmarks ...................................................................................32
Saving your work ........................................................................................33
Checking your work ....................................................................................33
Tutorial.book Page 3 Friday, November 16, 2007 3:27 PM
4
LESSON 2.HANDLING SHEETS AND SHEET OBJECTS .................... 35
Opening the document .................................................................................35
Presentation .................................................................................................36
Logical connections between sheets ............................................................36
Adding a sheet. ............................................................................................38
Moving a sheet ............................................................................................39
Adding new sheet objects ............................................................................40
Saving, closing and exiting .........................................................................46
LESSON 3.LIST BOXES AND STATISTICS BOXES .......................... 47
Opening the document .................................................................................47
The list box ..................................................................................................47
The statistics box .........................................................................................51
Saving, closing and exiting .........................................................................53
LESSON 4.BAR CHARTS AND PIE CHARTS ................................... 55
Introduction .................................................................................................55
Opening the document .................................................................................57
Changing chart types using a fast type change icon ....................................57
Making selections in a chart ........................................................................58
Moving and sizing .......................................................................................58
Creating a bar chart using the Quick Chart Wizard ....................................59
Creating a bar chart using the full chart wizard ..........................................61
Removing a chart .........................................................................................64
Changing a few properties ...........................................................................64
Cloning and detaching your chart ...............................................................66
Turning the bar chart into a pie chart ..........................................................67
Saving, closing and exiting .........................................................................70
LESSON 5.PIVOT TABLES AND STRAIGHT TABLES ....................... 71
Opening the document .................................................................................71
Adding a dimension to a bar chart ...............................................................71
Turning the chart into a multidimensional pivot table ................................72
Creating a straight table ...............................................................................76
Saving, closing and exiting .........................................................................82
LESSON 6.MORE CHART TYPES .................................................. 83
Opening the document .................................................................................83
Creating a line chart ....................................................................................83
Adding an expression to a bar chart ............................................................85
Turning the bar chart into a combo chart ....................................................86
Turning the combo chart into a scatter chart ...............................................87
Creating a scatter chart from scratch ...........................................................88
Creating a gauge chart .................................................................................89
Tutorial.book Page 4 Friday, November 16, 2007 3:27 PM
5
Working with a drill-down chart .................................................................91
Copying to Clipboard and printing ..............................................................92
Saving, closing and exiting .........................................................................93
LESSON 7.MULTI BOXES, TABLE BOXES AND INPUT BOXES ......... 95
Opening the document .................................................................................95
The multi box ..............................................................................................95
The table box ...............................................................................................98
Using an input box ....................................................................................101
Saving, closing and exiting .......................................................................103
LESSON 8.BUTTONS, TEXT OBJECTS AND LINE/ARROW OBJECTS ....
105
Opening the document ...............................................................................105
The button ..................................................................................................105
The text object ...........................................................................................109
The line/arrow object .................................................................................111
Saving, closing and exiting .......................................................................112
LESSON 9.SLIDER OBJECTS, CURRENT SELECTION OBJECTS &
BOOKMARK OBJECTS 113
Opening the document ...............................................................................113
The slider object ........................................................................................113
Creating a Current Selections Box ............................................................115
Creating a bookmark object ......................................................................115
Saving, closing and exiting .......................................................................116
LESSON 10.DOCUMENT PROPERTIES, USER PREFERENCES AND RE-
LOAD 117
Opening the document ...............................................................................117
Setting Document Properties .....................................................................117
User Preferences ........................................................................................121
Reloading data ...........................................................................................121
Saving, closing and exiting .......................................................................122
Checking your work ..................................................................................122
CREATING A DOCUMENT
INTRODUCTION ....................................................................... 125
Tutorial.book Page 5 Friday, November 16, 2007 3:27 PM