Tutorial

Tutorial.book Page 1 Tuesday, June 27, 2006 10:24 AM Tutorial Version 7 for Microsoft Windows® Second Edition, Lund, Sweden, June 2006 Authored by QlikTech International AB /KHN/JNN/MSJTutorial.book Page 2 Tuesday, June 27, 2006 10:24 AM Copyright © 1994-2006 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®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, 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 3 Tuesday, June 27, 2006 10:24 AMTutorial.book Page 4 Tuesday, June 27, 2006 10:24 AMTutorial.book Page 5 Tuesday, June 27, 2006 10:24 AM 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 Opening an existing file ..............................................................................19 Saving a document ......................................................................................19 Closing a .....................................................................................19 QlikView Help ............................................................................................20 Using Documents on a QlikView Server ....................................................20 WORKING WITH QLIKVIEW INTRODUCTION ......................................................................... 23 LESSON 1.MAKING QUERIES IN QLIKVIEW ................................... 25 Opening the document .................................................................................25 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, closing and exiting .........................................................................33 Checking your work ....................................................................................33 LESSON 2.SHEETS .................................................................... 35 Opening the document .................................................................................35 5Tutorial.book Page 6 Tuesday, June 27, 2006 10:24 AM Presentation .................................................................................................35 Logical connections between sheets ............................................................35 Adding a sheet .............................................................................................37 Moving a sheet ............................................................................................38 Adding sheet objects ...................................................................................38 Saving, closing and exiting .........................................................................39 LESSON 3.LIST BOXES AND STATISTICS BOXES .......................... 41 Opening the document .................................................................................41 The list box ..................................................................................................41 The statistics box .........................................................................................51 Saving, closing and exiting .........................................................................52 LESSON 4.BAR CHARTS AND PIE CHARTS ................................... 53 Introduction .................................................................................................53 .....................................................................................................................55 Opening the document .................................................................................55 Making selections in a chart ........................................................................55 Moving and sizing .......................................................................................56 Copying, minimizing, maximizing and restoring ........................................56 Changing chart types using a fast type change icon ....................................57 Creating a simple bar chart ..........................................................................57 bar chart using the full chart wizard ..........................................60 Removing a chart .........................................................................................63 Changing a few properties ...........................................................................63 Cloning and detaching your chart ...............................................................65 Turning the bar chart into a pie chart ..........................................................65 Saving, closing and exiting .........................................................................68 LESSON 5.PIVOT TABLES AND STRAIGHT TABLES ....................... 69 Opening the document .................................................................................69 Adding a dimension to a bar chart ...............................................................69 Turning the chart into a multidimensional pivot table ................................70 Creating a straight table ...............................................................................74 Saving, closing and exiting .........................................................................79 LESSON 6.MORE CHART TYPES .................................................. 81 Opening the document .................................................................................81 Creating a line chart ....................................................................................81 Adding an expression to a bar chart ............................................................83 Turning the bar chart into a combo chart ....................................................84 Turning the combo chart into a scatter chart ...............................................85 Creating a scatter chart from scratch ...........................................................86 gauge chart .................................................................................87 6Tutorial.book Page 7 Tuesday, June 27, 2006 10:24 AM Working with a drill-down chart .................................................................89 Copying to Clipboard and printing ..............................................................90 Saving, closing and exiting .........................................................................91 LESSON 7.MULTI BOXES, TABLE BOXES AND INPUT BOXES ......... 93 Opening the document .................................................................................93 The multi box ..............................................................................................93 The table box ...............................................................................................96 Using an input box ......................................................................................99 Saving, closing and exiting .......................................................................102 LESSON 8.BUTTONS, TEXT OBJECTS AND LINE/ARROW OBJECTS .... 103 Opening the document ...............................................................................103 The button ..................................................................................................103 The text object ...........................................................................................107 The line/arrow object .................................................................................109 Saving, closing and exiting .......................................................................110 LESSON 9.SLIDER OBJECTS, CURRENT SELECTION OBJECTS AND BOOKMARK OBJECTS 111 Opening the document .................................