QLIKVIEW

INTRODUCTION

Who is QlikTech ?

What is QlikView ?

Comparing QlikView with traditional tools.

QLIKVIEW DATA STRUCTURES

Data structures in QlikView (AQL)

Sample Application walkthrough of QlikView

Objectivity of Relevant search records (Gray area & White area in Dimension)

Why it’s called In-memory BI Tool

Thorough Architecture of QlikView (including Multiple Data Source & AJAX Client)

LOADING DATA INTO QLIKVIEW

Script editing

Edit Script Toolbar

Edit Script Menu Commands

Statements Area

Edit Script Tool Pane

Syntax

Renaming a Field

SCRIPTING CONSIDERATIONS

Adding Text Data

Loading an XML file

Reading the Shipments table

Synthetic key tables

Circular references

Causes of circular references

Renaming fields using the Qualify statement

OTHER USES OF EXPRESSIONS

Calculated Labels and Dynamic Text in Text Objects

Conditional Functions

Chart Attribute Expressions

Color Expressions

Calculated Fields in List Boxes

Calculated Dimensions in Charts

The Expression Overview Dialog

REPORTS AND BOOKMARKS

Introduction – Reports

QlikView Report Types

Managing Reports

Creating and editing reports

Introduction – Bookmarks

QLIKVIEW SECURITY

Access control

Access levels

Hidden script

Adding Section Access

EXERCISES

Script Debugging

STRUCTURING THE SCRIPT

Creating tabs in the script

SDATA STRUCTURE OF THE LOADED DATA

The Table Viewer

System fields

The system tab

The system table

Document Properties: Tables page

DATA SOURCE FILES

The QWT primary data source

The QWT secondary data files

CREATING THE SCRIPT

Script generation

Creating a connection to the database

Reading tables into QlikView

ADVANCED SCRIPTING

Condition on a field in a table

Aggregating Data in Script (Resident Load and Group Function, Order By etc)

Joining tables (Left, Right, Inner, Outer Joins)

Concatenation

Set Analysis

Apply Map

Interval Match

SERVER INTRODUCTION

Overview

System Requirements

Installation of QlikView Server

QLIKVIEW DATA (QVD) FILES

QVD file format

Use of QVD files

Creating QVD files

Manual creation of a QVD file in the script

Automatic Creation of a QVD file in the script

QVD file script functionsn

USING QLIKVIEW PERSONAL EDITION

Starting QlikView

Basic Layout and Navigation

SHEETS AND SHEET OBJECTS

Sheet Basics & Sheet Objects

THE TABLE BOX

Introduction

Creating a Table Box

Selections in Table Boxes

Sorting in Table Boxes

More Table Box formatting options

Printing data from a table box

Exporting data from a table box to a text file

THE MULTI BOX

Introduction

Selections in Multi Boxes

Creating a Multi Box

Resizing Multi Boxes

Formatting Multi Boxes

EXERCISES

Data Loading & Data Model

THE SETTINGS MENU

User Preferences

Document Properties

Sheet Properties

Inherited settings

THE LIST BOX

Introduction

Creating a List Box

List Box in Action

Properties of the List Box

THE TEXT OBJECT

Introduction

Creating Text Objects

Formatting, Resizing, Copying and Moving Text Objects

CHARTS

Chart Basics

Creating a Chart

Selections in Charts

Changing the Chart Properties for Existing Charts

Common Chart Types

Exporting charts

References in charts

MULTI DIMENSIONAL CHARTS, PIVOT TABLES, GAUGES

Straight Table with Multiple Expressions

Pivot Tables with Multiple Dimensions

Grouped bar charts

More about Pivot Tables and Straight Tables

Using a Dropdown Selection

Using Visual Cues

Summary – Comparing Tables

Types of Gauges

Building Gauges

BUTTONS

Buttons in QlikView

Creating and Formatting a Button

Shortcut Buttons

Launch/Export-Buttons

Edit Macro (on the fly Grouping/Sheet Enabled Disabled)

THE OTHER SHEET OBJECTS

The Statistics Box

The Current Selections Box

The Slider/Calendar Object

The Input Box

The Bookmark Object

The Custom Object

The Other Chart Types

ADDITIONAL EDITING IN THE LAYOUT

Title Settings

Fast Change Chart Type

Legend Settings

Reference Lines / Text in Chart

Advanced Caption Settings