Search for Training

QlikView Data & Scripting

Course Overview


The QlikView Data & Scripting training course provides knowledge of the features and capabilites of the QlikView scripting language that are essential to produce good quality and sustainable applications.

Course Content


Structuring Data

  • are written in a standardised and highly structured way
  • can be easily understood by anyone familiar with The QlickiT Methodology
  • can be easily amended or added to; and
  • provide a structure which makes incremental load and consolidation of different data sets simpler

Load data from database sources
Convert data into a standard QVD format
Understand the difference between Dimension and Transaction tables

Join tables using a link table
Create a common calendar

Use the standardised approach and templates defined in The Methodology
Manipulating Data

  • Create a new QlikView document from a Script file
  • Load data from database and other data sources
  • Specify selection criteria to Extract only the data required for your application
  • Format and Transform the data into the format required by your application
  • Concatenate and Join tables
  • Add data using Mapping tables and the ApplyMap function
  • Create Map Tables with an Inline Load
  • Add Calculated fields and create Flags
  • Use the standardised approach and templates defined in The Methodology

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

What is the sum of 5 + 1? (security question)

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234

Subscribe to our weekly newsletter