QLIKVIEW Course

QlikView is the most flexible Business Intelligence platform.

Qlikview Online Training

The purpose of this articleis to give you an introduction to QlikView and show to how to setup your first QlikView document so you can see QlikView in action. You will create your first QlikView document and use some random sales data and show how to create lists and a simple chart within QlikView.

What you will learn

More than 29000 organizations are using Qlikview for decision making. QlikView users can engage each other in discussions about QlikView content. A user can create notes associated with any QlikView object. Other users can then add their own commentary to create a threaded discussion.

  • Introduction to Qlikview

Qlikview Online Training Course Content

 

  • INTRODUCTION TO QLIKVIEW
  • 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:
  • ADDING TEXT DATA
  • Employees
  • Offices
  • Script generation using the File Wizard

 

  • 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?
  • 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
Back to top