QlikView Online Training

QlikView

Version - 11.2

What is QlikView?

How does QlikView differ from traditional BI

Associative user experience

Technology

Adoption path

Exploring data with QlikView

Getting QlikView

Navigating the document

Slicing and dicing your data

QlikView Menu

QlikView Sheet Objects

List Box

MultiBox

Statistics Box

Charts

Table Box

Search Object

BookMark Object

Slider/Calendar

Current Selection Box

Line/Arrow

Button

Text Object

Input Box

Container

Custom Bject

System Table

Document Properties

Sheet Properties

User Preference

The technology and components behind QlikView

The way the data flows

When QlikView use expands

Create content

Reload, publish, and distribute content

Consume content

Data Sources

Loading Data from Excel

XML File

Flat File

Access Database

Inline Table

QVD's & QVX

Uses of QVD

Advantage of QVD

Charts

Bar Chart

Line Chart

Combo Chart

Radar Chart

Guage Chart

Mekko Chart

Pivot Table

Straight Table

Block Chart

Funnel Chart

Pie Chart

Grid Chart

Scatter Chart

Waterfall Chart

Data Modelling

Star Schema

Snowflake Schema

Associative Data Model

Table Viewer Window

Table information

Field information

Table preview

Table viewer menu

QlikView Scripting

The Script Editor

Menu and toolbar

Script pane

Tool pane

QV Scripting

Synthetic keys

Circular Reference

Link Table

Interval Match

Resident load

The JOIN statement

The KEEP statement

The CONCATENATE statement

The NOCONCATENATE statement

sing MAPPING tables Adding comment

Storing tables

Renaming tables and fields

Deleting tables and fields

Setting variables

Controlling script flow

Conditional functions
Dealing with different data types

Strings

String operators

String functions

Numbers and numeric functions

Date and time functions

Master Calendar

Loading Cross Table

Generic load

Binary Load

Partial Reload

Preceding Load

QV Functions

Dual

Total

Aggr

Pick

Previous

Peek

Autogenerate

class

if

Set Analysis

Point In Time Reporting

Alternate states

Comparative analysis with alternate states

Data architecture

Two-stage architecture

Three-stage architecture

Setting up our environment

Hidden script
Section access

Section access fields

Reduction fields

Initial data reduction

Omitting fields

Document-level security

Sheet-level security

Summary

Chapter 14: Security
Hidden script
Section access

Section access fields

Reduction fields

Initial data reduction

Omitting fields

Document-level security
Sheet-level security
Summary