qlikview developer - essentials

By attending QlikView Developer - Essentials workshop, delegates will learn to:

  • Incorporate best practices for application design and layout in the development of QlikView applications.
  • Build a QlikView application using sheets and some of the common QlikView objects such as list boxes and table boxes.
  • Search and analyze data in existing QlikView applications.

QlikView Developer - Essentials Training Course provides you with an opportunity to learn by doing through a series of lectures and hands on exercises focused on developing QlikView applications. Beginning with the QlikView environment and ending with an introduction to advanced interface design, this course will prepare you to take your QlikView applications to the next level. This course concludes with a new business case where you can practice your skills in building a QlikView application from the beginning using identified key performance indicators.

For QlikView Developer - Essentials

  • Attending Qlikview Application Design Course or possess equivalent knowledge

  • QlikView Designers
  • QlikView Developers
  • Developers, Designers & Power End-Users

COURSE AGENDA

  • Script Generation
  • Comments in the Script
  • The Create Select Statement Dialog
  • Creating Tabs in the Script
  • Script Debugging
  • The Script Execution Log File
  • QlikView’s QVD File and format
  • Comparing Database Structures to QlikView Data
  • Structures
  • Data Structures in QlikView
  • QlikView Data Modeling
  • Introduction to Scripting
  • The QWT Project Data, Primary & Secondary Data Source
  • QlikView Desktop, Server and Publisher
  • The File Wizard
  • Your Excel Files
  • Script generation using the File Wizard
  • Load Statement
  • Renaming a Field
  • Script Expressions
  • Loading an XML File
  • The Qualify Statement, Key Fields, Count and Sum
  • Cross Tables and Input field
  • Dimension Limits
  • Perform comparative analysis using Alternate
  • States
  • Set Analysis
  • Dollar-Sign Expansion & Aggr Function
  • Tags, Comments & Renaming
  • Null functions
  • HidePrefix & HideSuffix
  • QVD File Format and its use
  • Creating QVD Files
  • Store Statement
  • Manual Creation of a QVD File in the Script
  • Resident Load
  • The Where Exists Clause
  • More about Synthetic Keys
  • Synthetic Key Tables
  • Composite Keys
  • Circular References
  • Loosely Coupled Tables
  • Eliminating Circular Reference
  • Date and Time
  • The Master Calendar
  • Using Flags
  • Data & Date Islands
  • Mapping Tables
  • Cleaning up the Table Structure
  • Preceding Load on Preceding Load
  • How to Create QlikView Data Models
  • Joining tables
  • Concatenation
  • From Snow Flake to Star Scheme
  • Merged Facts Table
  • Aggregating Data
  • Link Tables and Concatenated Tables
  • Calculating Net Change within a Field
  • Dynamic Aggregation
  • Performance Tuning
  • Best Practices for QlikView File Optimization
  • 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

Copyright © 2026 All Rights Reserved by Cuesys Infotech.

Designed By  99 DESIGN AGENCY