Qlikview

Tutorial

Version 9 for Microsoft Windows® Second Edition, Lund, Sweden, January 2010 Authored by QlikTech International AB /KHN/JNN/MSJ/JHS

Copyright © 1994-2009 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-readableform, in whole or in part, without the prior written permission of QlikTech International AB, except in the manner described in the software agreement. Qlik®Tech and Qlik®View are registered trademarks of QlikTech International AB. Microsoft, MS-DOS, Windows, Windows NT, Windows 2000, Windows 2003, Windows XP, SQL Server, FoxPro, Excel, Access and MS Query are trademarks of MicrosoftCorporation. 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? ................................................................ 11 ABOUT THETUTORIAL .............................................................. 13 CONVENTIONS .......................................................................... 15
General conventions ....................................................................................15 Mouse conventions ......................................................................................15 Keyboardconventions .................................................................................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 INQLIKVIEW ................................. 25
Opening the document .................................................................................25 Basic QlikView terminology .......................................................................26 Selections .....................................................................................................26 Text searches and numericsearches ............................................................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

LESSON 2.HANDLING SHEETS AND SHEET OBJECTS ................... 35
3

Opening the document .................................................................................35 Presentation...