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

Advanced Qlikview

Two Day Course

 

QlikView as a tool:

  • Comparison over the traditional BI tools

  • Principles behind associative modelling

  • How QlikView treats the data and models them as per it’s in memory conventions

  • Configuring Density Ratio and subset ratio to identify the table and fact structures

 

QlikView as Datamart ETL:

  • Types of loads ( Preceding, Partial, Binary, Incremental)

  • Coding conventions and scripting features of QlikView

  • Debugging the script

  • Creating QVD’s along with their usage and drawbacks

  • Creating runtime tables using pre-calculated functions and ETL functions

  • Cleansing of data to create data model over QV scripting

 

QlikView as a Reporting and Visualization:

  • Overview of all the components and their features

  • Recommending look and feel to the end user expectations

  • Applying security modules to the QV layouts

  • Tweaking the components to achieve the desired look and feel of dashboarding

  • Creating scorecards and KPI’s

 

Restricting QV associative behavior:

  • Implementing alternate states

  • Creating sets and restricting the data behavior as per user and KPI needs.

  • Dynamically changing the colors of the layout as per logics and predefined functions.

 

Implementing QlikView from the end users perspective:

  • Inserting buttons and actions as per the features to drive end user requirements

  • Scenarios of end users expectations by implementing user response actions.

  • Section access for security.

  • Creating out of box Visualizations.

  • Driving users experience over the charts and their features.

 

Deploying the QV application over Access point:

  • Visual science behind creating QV dashboards

  • Factors to be considered before deployment

  • Best practices for coding and designing the script layout for performance tuning.

© 2018 by The Enigma Group of Companies

  • Instagram Social Icon
  • Facebook Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon