The following topics will be covered as part of QlikView Developer Training.

THE ASSOCIATIVE EXPERIENCE WITH QLIKVIEW

The Associative Power of QlikView

The difference between traditional BI and QlikView

QlikView Basic Navigation

INTRODUCTION TO DATA AND SCRIPTING

QlikView’s QVD File and format

Comparing Database Structures to QlikView Data Structures

Data Structures in QlikView

QlikView Data Modeling

Introduction to scripting

LOADING DATA FROM THE DATABASE

Script Generation

Comments in the Script

The Create Select Statement Dialog

Creating Tabs in the Script

Script Debugging

The Script Execution Log File

SYNTHETIC KEYS

1.BASIC DATA MODEL AND TABLE VIEWER

2.ADDING TEXT DATA

The File Wizard

Your Excel Files

Script generation using the File Wizard

3.BASIC DATA TRANSFORMATION

Load Statement

Renaming a Field

Script Expressions

The Qualify Statement, Key Fields, Count and Sum

QLIKVIEW DATA (QVD) FILES

QVD File Format and its use

Creating QVD Files

Store Statement

Manual Creation of a QVD File in the Script

QLIKVIEW DESIGN CONCEPTS

Visual Perception, Consistency

Project Template, Sheets

Multi Box

Selections in Table Boxes, sorting & formatting

Exporting data from a table box to a text file

Text Object

DISCOVERING CHARTS

Charts

Objects: Dimensions and Expressions

Dimension Limits

Pivot & Straight Table

Groups

Gauge, Text Objects, Bookmarks

Statistics Box & Container Objects

EXTENSIONS

Working with Extensions

OTHER SHEET OBJECTS

The Slider/Calendar Object

The Input Box

Buttons in QlikView

Actions

The Line/Arrow Object

GENERATING DATA IN THE QLIKVIEW SCRIPT

Resident Load

The Where Exists Clause

SCRIPTING CONSIDERATIONS

More about Synthetic Keys

Synthetic Key Tables

Composite Keys

Circular References

Loosely Coupled Tables

Eliminating Circular Reference

MAPPING TABLES

Mapping Tables

QLIKVIEW SECURITY

Access control
Access levels
Hidden script
Adding Section Access

Live Project and guidance

Duration & Timings :

Duration – 30 Hours.

Training Type: Instructor Led Live Interactive Sessions.

Faculty: Experienced.

Weekday Session – Mon – Thu 8:30 PM to 10:30 PM (EST) – 4 Weeks. April 10, 2023.

Weekend Session – Sat & Sun 9:30 AM to 12:30 PM (EST) – 5 Weeks. April 29, 2023.

 Inquiry Now         Discount Offer 

USA: +1 734 418 2465 | India: +91 40 4018 1306