Qlik view Training

INTRODUCTION

WHAT IS Reporting/Business Intelligence?

Why BI tool required?

WHAT IS QLIKVIEW?

Merits & Demerits of Qlikview

Basic Qlikview Terminology-QVW,QVD,QVX,Fields etc.

Qlikview Architecture-QVS, QVP

BASICS

StartingQlikView

The Start Page

Opening a document

Saving a document

Closing a document

QlikView Help

Using Documents on a QlikView Server

WORKING WITH QLIKVIEW INTRODUCTION

Loading Data from different sources

ODBC, OLEDB connections

Other connections

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

Saving your work

Checking your work

HANDLING SHEETS AND 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 AND STATISTICS BOXES

Opening the document

The list box

The statistics box

Saving, closing and exiting

BAR CHARTS AND 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 AND 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 119

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 AND 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

What’s next?

ADVANCED FEATURES INTRODUCTION DATA MODELING

Creating a simple data model>

Finding synthetic keys

Removing Synthetic keys

Creating keys/composite keys/renaming/Auto number

LOAD INLINE

Adding a record with load inline

Adding a table with load inline

FIELD GROUPS AND CYCLIC DISPLAY

Field groups

Cyclic display of expressions

VARIABLES

Working with Variables

TRIGGERS

Working on triggers

Create an action

CONFIGURATION

Connection string configuration

Scheduling data load

Auto reloads application

SECURITY

Data level security

Sections in the Script

Access levels

Loading security tables

Using the Security pages

Opening a document with access restriction

WHAT’S NEXT?

QlikViewTraining Program

QlikCommunity

QlikViewDemo Applications

Nprinting