Manual Qlikview

Tutorial

Version 8 for Microsoft Windows® First Edition, Lund, Sweden, June 2007 Authored by QlikTech International AB /KHN/JNN/MSJ/JHS

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, inwhole or in part, without the prior written permission of QlikTech International AB, except in the manner described in the software agreement. Qlik®View is a registered trademark of QlikTech International AB. In the United States of America and Canada, Qlik®View is a registered trademark of Qlik®Tech, Inc. Microsoft, MS-DOS, Windows, Windows NT, Windows 2000, Windows 2003, Windows 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 Corporation. 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.

CONTENT
INTRODUCTION

WHAT IS QLIKVIEW?................................................................ 13
Flavors of QlikView ....................................................................................13

ABOUT THE TUTORIAL .............................................................. 15 CONVENTIONS .......................................................................... 17
General conventions....................................................................................17 Mouse conventions ......................................................................................17 Keyboard conventions .................................................................................18 Regional settings .........................................................................................18 BASICS.................................................................................... 19 Starting QlikView ........................................................................................19 The start page ..............................................................................................19 Opening an existing file ..............................................................................19 Saving a document......................................................................................20 Closing a document .....................................................................................20 QlikView Help ............................................................................................20 Using Documents on a QlikView Server ....................................................20WORKING WITH QLIKVIEW

INTRODUCTION ......................................................................... 25
LESSON 1.MAKING QUERIES IN QLIKVIEW ................................... 27 Opening the document .................................................................................27 Basic QlikView terminology .......................................................................28Selections .....................................................................................................28 Text searches and numeric searches ............................................................32 Stepping back or forward in the list of selections .......................................33 Locking and unlocking selections...............................................................33 Selection bookmarks ...................................................................................34 Saving your work ........................................................................................35 Checking your work ....................................................................................35

5

LESSON 2.HANDLING SHEETS AND SHEET OBJECTS .................... 37...