New Courses

QlikView Online Training

  • Course Overview
  • Target Audience
  • Why choose us
  • Trainer Profile

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

N/A

N/A

N/A

You may be also interested in

Register for FREE Demo

Fields marked with (*) are mandatory

* Name:
* Email:
* Phone:
* Location:
* Course:
* Enquiry:
* Captcha:

 

Client Feedback

Thanks, you guys provided the best online training in SAP BODS. The hands on training is very informative and helpful.

- David Sergi, Camaga Ltd; U.K