Qlikview Online Training

qlikview online training

QlikView Online Training

Duration: 25 hours

 1. INTRODUCTION TO QLIK VIEW

  • Target Audience
  • What You Will Learn in this Course
  • Course Logistics
  • Notes

2. QLIKVIEW ENVIRONMENT

  • QlikView Desktop

3. QLIKVIEW DEVELOPMENT METHODOLOGIES

  • Import/Export Sheet and Document Layouts as XML
  • Qlik Wholesale Trade (QWT) Project Plan
  • Project Plan Review
  • SAFE Methodology

4. DEPLOYMENTS

  • QlikView Standalone
  • QlikView Server
  • QlikView Publisher 

5. 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

6. BASIC SCRIPT SYNTAX

  • Syntax 

7. LOADING DATA FROM THE DATABASE

  • Script Generation
  • Comments in the Script
  • Script Debugging

8. STRUCTURING THE SCRIPT

  • Creating Tabs in the Script 

9. BASIC DATA MODEL AND TABLE VIEWER

  • The Table Viewer
  • The System Table
  • Document Properties: 

10. 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?

11. ADDING TEXT DATA

  • Employees
  • Offices
  • Script generation using the File Wizard

12. 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

13. SCRIPTING CONSIDERATIONS

  • Synthetic Key Tables
  • Circular References
  • Causes of Circular References
  • Check the Numbers

14. 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

15. REPORTING BUGS IN QLIKVIEW

16. ADDITIONAL INFORMATION

  • Reference Materials
  • Data types in QlikView

17. APPENDIX: LAYOUT BASICS FOR DEVELOPERS

  • User Friendly Design
  • Natural Human Behavior
  • Chart and Object Choices in QlikView
  • Import/Export Sheet and Document Layouts

18. APPENDIX: The Completed Script