Tutorial

Tutorial

-

English
227 Pages
Read
Download
Downloading requires you to have access to the YouScribe library
Learn all about the services we offer

Description

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? ............................................... ...

Subjects

Informations

Published by
Reads 260
Language English
Document size 6 MB
Report a problem
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 ...............................................................................111 Creating a slider object ..............................................................................111 Using a slider object ..................................................................................113 Creating a bookmark object ......................................................................114 Saving, closing and exiting .......................................................................115 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 7 Tutorial.book Page 8 Tuesday, June 27, 2006 10:24 AM LESSON 11.LOADING DATA INTO QLIKVIEW .............................. 127 Looking at a delimited text file .................................................................128 Loading the text file ..................................................................................129 Saving, closing and exiting .......................................................................134 LESSON 12.ASSOCIATING DATA FROM MANY TABLES ............... 137 Associations ...............................................................................................137 Opening the document ...............................................................................138 Loading and associating a second table ....................................................139 Renaming fields .........................................................................................141 Saving, closing and exiting .......................................................................144 LESSON 13.CONCATENATING TABLES ...................................... 145 Opening the document ...............................................................................145 Automatic concatenation ...........................................................................145 Forced concatenation .................................................................................148 Using the Table Viewer .............................................................................151 Improving the layout .................................................................................152 Saving, closing and exiting ...................................153 LESSON 14.LINKING EXTERNAL INFORMATION TO A DOCUMENT 155 Opening the document ...............................................................................155 Looking at an info file ...............................................................................155 Loading the info file ..................................................................................156 Viewing the linked information ................................................................157 Embedding external info ...........................................................................159 Saving, closing and exiting .......................................................................159 LESSON 15.LOADING ADDITIONAL FILES ................................... 161 Opening the document ...............................................................................161 Loading a tab separated file without labels ...............................................162 Loading a file via ODBC ...........................................................................163 Saving, closing and exiting .......................................................................166 ADVANCED FEATURES INTRODUCTION ....................................................................... 169 LESSON 16.MORE ABOUT ASSOCIATIONS ................... 171 Creating a system sheet .............................................................................171 Using the system sheet ..............................................................................172 8 Tutorial.book Page 9 Tuesday, June 27, 2006 10:24 AM Creating a system table ..............................................................................174 Showing frequency in associating fields ...................................................175 LESSON 17.LOAD INLINE ......................................................... 179 Adding a record with load inline ...............................................................179 Mapping data with load inline ...................................................................180 LESSON 18.FIELD GROUPS AND CYCLIC DISPLAY ...................... 185 Field groups ...............................................................................................185 Cyclic display of Expressions ...................................................................191 LESSON 19.HANDLING CROSS TABLES ..................................... 193 Loading a cross table .................................................................................193 Loading a cross table with more than one regular column ........................195 LESSON 20.AND-MODE IN A LIST BOX ...................................... 199 Making an and-selection ...........................................................................199 Making a not-selection ..............................................................................200 Characteristics of the and-table .................................................................201 LESSON 21.SEMANTIC LINKS ................................................... 203 Working with semantic links .....................................................................203 Creating a document with semantic links ..................................................203 LESSON 22.NUMBER FORMATS ................................................ 209 Interpretation and formatting .....................................................................209 Interpretation of data .................................................................................209 Formatting of data .....................................................................................214 LESSON 23.ACCESS RESTRICTION ........................................... 217 Access levels .............................................................................................217 Sections in the Script .................................................................................217 Section Access system fields .....................................................................218 Loading security tables ..............................................................................219 Using the Security pages ...........................................................................222 Working with access restriction ................................................................222 9 Tutorial.book Page 10 Tuesday, June 27, 2006 10:24 AM 10