Introduction to QlikView

Introduction 

• What Is QlikView? 

• About TheOverall Course 

• QlikView Basics 

 

Making Queries in QlikView

• Opening the document 

• Basic QlikView terminology 

• Selections 

• Stepping back or forward in the list of 

• selections

• Locking and unlocking selections 

• Searching values 

• Selection bookmarks 

• Saving your work 

• Checking your work 

 

Handling Sheets & Sheet Objects 

• Opening the document 

• Sheets 

• Logical connections between sheets 

• Adding a sheet 

• Moving a sheet 

• Adding new sheet objects 

• Saving, closing and exiting 

 

List Boxes & Statistics Boxes 

• Opening the document 

• The list box 

• The statistics box 

• Saving, closing and exiting 

 

Bar Charts & Pie Charts 

• Introduction 

• Opening the document 

• Making selections in a chart 

• Changing chart types using a fast type change 

• icon

• Creating a bar chart using the Quick Chart 

• Wizard 

• Creating a bar chart using the full chart wizard 

• Removing a chart 

• Changing a few properties 

• Cloning and detaching your chart 

• Turning the bar chart into a pie chart 

• Saving, closing and exiting 

 

Pivot Tables & Straight Tables 

• Opening the document 

• Adding a dimension to a bar chart 

• Turning a bar chart into a multidimensional 

• pivot table 

• Creating a straight table 

• Saving, closing and exiting 

 

More Chart Types 

• Opening the document 

• Creating a line chart 

• Adding an expression to a bar chart 

• Turning the bar chart into a combo chart 

• Turning the combo chart into a scatter chart 

• Creating a scatter chart from scratch 

• Creating a gauge chart 

• Working with drill-down functionality 

• Copying to Clipboard and printing 

• Saving, closing and exiting 

 

Multi Boxes, Table Boxes and Input Boxes 

• Opening the document 

• The multi box 

• The table box 

• Using an input box 

• Saving, closing and exiting 

 

Buttons, Text Objects And Line/Arrow 

• Objects 

• Opening the document 

• The text object 

• The line/arrow object 

• The button 

• Saving, closing and exiting 

 

Sliders Current Selection Objects and Bookmark Objects 

• Opening the document 

• The slider/calendar object (in slider mode) 

• Creating a Current Selections box 

• Creating a bookmark object 

• Saving, closing and exiting

• Document Properties, User 

• Preferences & Reload 

• Opening the document 

• Setting Document Properties 

• User Preferences 

• Reloading data 

• Saving, closing and exiting 

• Checking your work 

• What's next? 

 

CREATING A DOCUMENT 

• Introduction 

• Loading Data into QlikView

• Looking at a delimited text file 

• Creating a new QlikView document 

• Loading a text file into QlikView

• Saving, closing and exiting 

 

Associating Data from Many Tables 

• Associations 

• Opening the document 

• Loading and associating a second table 

• Renaming fields 

• Saving, closing and exiting 

• Concatenating Tables 

• Opening the document 

• Automatic concatenation 

• Forced concatenation 

• Saving, closing and exiting 

 

The Table Structure 

• Using the Table Viewer 

• Labeling tables in the script 

• Improving the layout 

• Saving, closing and exiting 

• Layout Themes 

• Creating a theme 

• Applying a theme 

• Saving, closing and exiting 

 

Loading Additional Files 

• Opening the document 

• Loading a tab separated file without labels 

• Loading a file via OLE DB 

• Saving, closing and exiting 

 

Linking External Information to a Document 

• Opening the document 

• Looking at an info table 

• Loading the info table 

• Viewing the linked information 

• Embedding external info 

• Displaying info in a text object 

• Saving, closing and exiting 

 

Advanced Features 

• Introduction 

• More about Associations 

• Creating a system sheet 

• Using the system sheet 

• Creating a system table 

• Showing frequency in key fields 

 

Load Inline 

• Adding a record with load inline 

• Adding a table with load inline ​

​

​​Field Groups & Cyclic Display 

• Field groups 

• Cyclic display of expressions ​

​

Loading Cross Tables 

• Loading a cross table 

• Loading a cross table with more than one 

• regular column 

• And-Mode in List Box 

• Making an and-selection 

• Making a not selection 

• Characteristics of the and table ​​

​

​​Number Formats 

• Handling of numeric data 

• Interpretation of numeric data 

• Formatting of data

​

​​Security 

• Sections in the Script 

• Access levels 

• Security fields 

• Loading security tables 

• Using the Security pages 

• Opening a document with access restriction