QLICK VIEW


QLIKVIEW ENVIRONMENT

INTRODUCTION TO DATA AND SCRIPTING

  • Relational Databases
  • Other Data Structures
  • comparing Database Structures to QlikView Data Structures
  • Data Structures in QlikView
  • Data Source Files
  • The QVD Primary Data
  • 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: Tables page

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

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

QLIKVIEW DATA (QVD) FILES


ADDITONAL 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
  • APPENDIX: The Completed Script
  • QLIKVIEW_Developer

DEVELOPER TOOLS

  • Troubleshooting
  • The Debugger

MAPPING TABLES

  • Mapping Quarters to the Orders table
  • MonthYear
  • Cleaning up the table structure

LOADING BUDGET DATA

  • Reading Cross Tables

ADVANCED SCRIPTING

  • Condition on a field in a table
  • Aggregating Data
  • Joining tables
  • Concatenation
  • Preceding Load on Preceding Load

ADVANCED CALCULATIONS IN SHEET OBJECTS

  • Set Analysis
  • Dollar-Sign Expansion
  • AGGR Function

SCRIPTING AND DATA MODELING CHALLENGES

  • Link Tables and Concatenated Tables
  • Calculating net change within a field
  • Functions InDate, Data & DateIslands
  • Aggr()
  • Class()
  • Dynamic Aggregation
  • IntervalMatch

DATA MODEL OPTIMIZATION

  • Performance Tuning
  • Best Practices for QlikView File Optimization
  • Creating Incremental Loads

QLIKVIEW SECURITY

  • Access control
  • Access levels
  • Access control database
  • Inherited access restrictions
  • Hidden script
  • Adding Section Access
  • Access control for certain commands
  • Further access control
  • Unattended Command Line Reload Considerations
  • Access restrictions on selected field values
  • Field value limitation in Section Access

ADVANCED DATABASE CONNECTIVITY

  • Custom Data
  • SAP Connector

QLIKVIEW SERVER & PUBLISHER


QLIKVIEW DEPLOYMENT CONFIGURATIONS

  • Company Requirements
  • User Requirements
  • What configuration to choose?
  • QlikView Standalone
  • QlikView Server
  • QlikView Server & Publisher

LICENSES AND SERVER TYPES

  • License Overview
  • Server
  • Client Access Licenses
  • Publisher
  • Local Clients

INTERACTION OF SERVER AND PUBLISHER COMPONENTS

  • Workflow and architecture of Document Management & Display
  • Document Levels: Script, Data & Layout
  • Overall Architecture QlikView 10, technical point of view
  • Functional overview of main components
  • Deployment of application in QEMC

INTERACTION OF SERVER AND PUBLISHER COMPONENTS

  • Workflow and architecture of Document Management & Display
  • Document Levels: Script, Data & Layout
  • Overall Architecture QlikView 10, technical point of view
  • Functional overview of main components
  • Deployment of application in QEMC

TROUBLESHOOTING

  • AccessPoint does not work
  • The QlikView Web Server service can't be started
  • AccessPoint displays no content
  • Details can't be displayed in the QEMC or QMC
  • The QEMC or QMC don't work at all