QlikView QlikSence
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
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
EXERCISES
Script Debugging
STRUCTURING THE SCRIPT
Creating tabs in the script
DATA STRUCTURE OF THE LOADED DATA
The Table Viewer
System fields
The system tab
The system table
Document Properties: Tables page
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
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 functions
QLIKVIEW SECURITY
Access control
Access levels
Hidden script
Adding Section Access
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
REPORTS AND BOOKMARKS
Introduction – Reports
QlikView Report Types
Managing Reports
Creating and editing reports
Introduction – Bookmarks
USING QLIKVIEW PERSONAL EDITION
Starting QlikView
Basic Layout and Navigation
SHEETS AND SHEET OBJECTS
Sheet Basics &Sheet Objects
THE LIST BOX
Introduction
Creating a List Box
List Box in Action
Properties of the List Box
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
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
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
EXERCISES
Script Debugging
STRUCTURING THE SCRIPT
Creating tabs in the script
DATA STRUCTURE OF THE LOADED DATA
The Table Viewer
System fields
The system tab
The system table
Document Properties: Tables page
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
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 functions
QLIKVIEW SECURITY
Access control
Access levels
Hidden script
Adding Section Access
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
REPORTS AND BOOKMARKS
Introduction – Reports
QlikView Report Types
Managing Reports
Creating and editing reports
Introduction – Bookmarks
USING QLIKVIEW PERSONAL EDITION
Starting QlikView
Basic Layout and Navigation
SHEETS AND SHEET OBJECTS
Sheet Basics &Sheet Objects
THE LIST BOX
Introduction
Creating a List Box
List Box in Action
Properties of the List Box
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
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 List
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
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
THE SETTINGS MENU
User Preferences
Document Properties
Sheet Properties
Inherited settings
SERVER INTRODUCTION
Overview
System Requirements
Installation of QlikView Server
CONFIGURING LDAP
CUSTOM USERS CREATION
SECURITY
Authorization
NTFS authorization
DMS authorization
Authentication
LICENSING
Client Access License CAL Types
USER DOCUMENT MAPPING
ARCHITECTURE
QlikView Server
Web Server
QlikView with Publisher
QlikView without Publisher
Qlikview Services
Introduction
Selections in Multi Boxes
Creating a Multi Box
Resizing Multi Boxes
Formatting Multi Boxes
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 List
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
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
THE SETTINGS MENU
User Preferences
Document Properties
Sheet Properties
Inherited settings
SERVER INTRODUCTION
Overview
System Requirements
Installation of QlikView Server
CONFIGURING LDAP
CUSTOM USERS CREATION
SECURITY
Authorization
NTFS authorization
DMS authorization
Authentication
LICENSING
Client Access License CAL Types
USER DOCUMENT MAPPING
ARCHITECTURE
QlikView Server
Web Server
QlikView with Publisher
QlikView without Publisher
Qlikview Services
Want to Learn
QlikView QlikSence
?
QlikView training in Deccan
QlikView testing institutes in Hinjewadi
QlikView coaching center and certification
QlikView certification in pune
live QlikView training pune
QlikView classes
QlikView training akurdi
QlikView training wakad
hire offshore QlikView testers
QlikView training classes pune
QlikView training pune
QlikView QlikView training in pune
hire QlikView candidates
QlikView course in pune
QlikView training
QlikView administration training pune
best QlikView training institute in pune
job oriented QlikView training
QlikView classes in pune
QlikView training institute in pune
QlikView trainers
QlikView personal trainers in pune
QlikView corporate training in pune
QlikView job guaranteed classes in pune
QlikView jobs in pune
computer training institute for QlikView
QlikView training institute
QlikView classes and placement
QlikView training and placement
QlikView training in pune
QlikView training institute with 100 percent job guarantee
job oriented training in QlikView
best QlikView training institute in pune
best QlikView classes in pune
complete QlikView course in pune
QlikView classes in wakad
QlikView training and placement in pune
QlikView classes in nigdi
QlikView tutorial
QlikView training institute in nigdi
QlikView live project training
QlikView training institute in hinjewadi
best placement agency for QlikView
QlikView placement agency
QlikView training institute in akurdi
complete QlikView training in pune
QlikView training institute in chinchwad
QlikView training institute in wakad
job guaranteed training in QlikView pune
QlikView classes in akurdi
QlikView classes in deccan-shivaji nagar
QlikView classes in chinchwad-pimpri
QlikView online classes
QlikView classes in hinjewadi
QlikView classes in akurdi
QlikView internship
best QlikView trainers in pune
best QlikView corporate faculty
best QlikView corporate trainers
