Qlikview course for Intermediate trainees by Satori Technologies and Solutions Private Limited

Qlick View
INTRODUCTION TO QLIK VIEW
Target Audience
What You Will Learn in this Course
Course Logistics
Notes
QLIKVIEW ENVIRONMENT
QlikView Desktop
QLIKVIEW DEVELOPMENT METHODOLOGIES
Import/Export Sheet and Document Layouts as XML
Qlik Wholesale Trade (QWT) Project Plan
Project Plan Review
SAFE Methodology
DEPLOYMENTS
QlikView Standalone
QlikView Server
QlikView Publisher
INTRODUCTIONS TO DATA AND SCRIPTING
Relational Databases
Other Data Structures
Comparing Database Structures to QlikView Data Structures
Data Structures in QlikView
Data Source Files
The QWT Primary Data Source
The QWT Secondary Data Files
Introduction to Scripting
BASIC SCRIPT SYNTAX
Syntax
LOADING DATA FROM THE DATABASE
Script Generation
Comments in the Script
Script Debugging
STRUCTURING THE SCRIPT
Creating Tabs in the Script
BASIC DATA MODEL AND TABLE VIEWER
The Table Viewer
The System Table
Document Properties:
BASIC DATA TRANSFORMATION
Load Statement
Renaming a Field
Script Expressions
Loading an XML File
Renaming Fields Using the Qualify Statement
Key Fields
Example Predicament
How Does this Affect You?
Loading a Field into a Table Multiple Times
Using a Record Counter on Key Fields
Is it Correct?
ADDING TEXT DATA
Employees
Offices
Script generation using the File Wizard
GENERATING DATA IN THE QLIKVIEW SCRIPT
Resident Load
Using Orders to determine Sales Person.
Include
Time Functions: Creating a Calendar
Getting the Highest and Lowest Date from the Orders Table
Autogenerate tables
Creating Variables in the Script
The Master Calendar
SCRIPTING CONSIDERATIONS
Synthetic Key Tables
Circular References
Causes of Circular References
Check the Numbers
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
REPORTING BUGS IN QLIKVIEW
ADDITIONAL INFORMATION
Reference Materials
Data types in QlikView
APPENDIX: LAYOUT BASICS FOR DEVELOPERS
User Friendly Design
Natural Human Behavior
Chart and Object Choices in QlikView
Import/Export Sheet and Document Layouts