Qlikview Course Content



1. USING QLIKVIEW 11.0 SR-2 PERSONAL EDITION

1.1 Starting QlikView

1.2 Basic Layout and Navigation

2. SHEETS AND SHEET OBJECTS

2.1 Sheet Basics

2.2 Sheet Objects

2.3 Exercises: Creating Your Workspace

3. LOADING DATA INTO QLIKVIEW

3.1 Script editing

3.2 Edit Script Toolbar

3.3 Edit Script Menu Commands

3.4 Statements Area

4. CREATING THE SCRIPT

4.1 Script generation

4.2 Creating a connection to the database

4.3 Reading tables into QlikView

5. SCRIPTING CONSIDERATIONS and Data Modelling

5.1 Reading the QWT MDB.

5.2 Synthetic key tables

5.3 Circular references

5.4 Causes of circular references

5.5 Loosely Coupled Tables

6. LOADING AN XML FILE

6.1 Loading a text file in XML Format

6.2 Renaming fields using the Qualify statement

7. ENERATING DATA IN THE QLIKVIEW SCRIPT

7.1 Resident Load

7.2 Inline tables

7.3 Auto generate tables

8. MAPPING TABLES

8.1 Mapping Quarters to the Orders table

8.2 Month Year

8.3 Cleaning up the table structure

9. QLIKVIEW DATA (QVD) FILES

10. QLIKVIEW SECURITIES

11. ADVANCED SCRIPTING

12. SET ANALYSES

13. MOST OF THE UNKNOWN QLIKVIEW FUNCTIONS

14. ALERETS AND TRIGGERS

15. REPORTS FOR PDF


16. MISCELLANEOUS TOPICS