Courses
SAVE – Special Offers – Click Here...
Latest News
SAVE – Special Offers – Click Here...

Qlikview - Developer 2 Day

Enquire About This Course

Qlikview Developer 2 Day training Course in Belfast Northern Ireland

Course Outcomes

Delegates will learn:

  • Data model
  • Creation of the proper data connections
  • Scripting fundamentals 

Course Outline

Working with Data Sources

  • Using ODBC and OLE DB drivers
  • Accessing custom data sources
  • Extracting data-two hands-on examples
  • Extracting data from Excel, CSV
  • The resulting data model
  • Loading a table file
  • QVD and QVX files
  • Loading an Inline table

Data Modelling

  • Dimensional data modelling
  • Relational databases and ER modelling
  • Dimensional Modelling Schemas
  • Dimensional models in QlikView
  • How associations are created
  • Avoiding data model conflicts
  • The Table Viewer window
  • Hands on sessions 

Qlikview Scripting Features

  • The Script Editor
  • Menu and toolbar
  • Script pane
  • Tool pane
  • Script statements
  • Synthetic keys
  • Synthetic Key tables
  • Composite keys
  • Manipulating tables
  • The Lookup Function
  • Concatenate Function
  • Joins
  • Conditional functions
  • Debugging script
  • organizing script
  • Re-using scripts

Data Transformation Basics

  • Changing the source table structure
  • Cleansing a dirty table
  • File contents
  • Working with the Transformation Step wizard
  • The final result
  • Expanding a hierarchy
  • Working with the Hierarchy Wizard
  • The tree-view list-box
  • Generic load
  • Loading a generic table into QlikView
  • Comparative analysis
  • A comparative analysis example 

Advanced Expressions

  • Using variables
  • Creating a variable
  • Using variables in charts
  • Interactively changing a variable's value
  • Using variables based on expressions
  • Using variables to store expressions
  • Variable naming convention
  • The Dollar Sign Expansion syntax
  • The Aggr function
  • Using Aggr for nested aggregation
  • Conditional functions
  • The If function
  • String Functions
  • Subfield
  • Len
  • Index
  • MinString
  • MaxString
  • Subfieldcount

Set Creation with Point In Time Reporting

  • Set Analysis Basics
  • Dynamic record sets
  • More assignment operators
  • Set operators
  • Using element functions
  • Point In Time Reporting (Basics)
  • The challenge
  • Defining the set modifiers

Advanced Data Transformations

  • Data architecture
  • Two-stage architecture
  • Loading data already stored in QlikView
  • Cloning a QlikView data model
  • Loading from RAM
  • IntervalMatch Function
  • Peek Function
  • Hands on sessions
  • 7: Securing Workbooks
  • Access Control
  • Access Levels
  • Access Control Database
  • Inherited Access Restrictions
  • Hidden script
  • Adding Section access
  • Section access fields
  • Reduction fields
  • Initial data reduction
  • Omitting fields
  • Document-level security
  • Sheet-level security

Macros and Automation

  • Using Automation Macros
  • Internal Macro Interpreter
  • Getting hold of a QlikView Document
  • VB Script Functions
  • Using macros in QV document
Enquire About This Course
Latest News
SAVE – Special Offers – Click Here...