The course follows the design and development of a complete QlikView application for a fictional company and introduces each new concept with a set of business requirements. By the end of the course you will have your first QlikView project under your belt, and have built a complete QlikView application yourself that you can take away with you for future reference.
Topics - QlikView Desktop
Topics - Relational Databases, Other Data Structures, Comparing Database, Structures to QlikView Data Structures, Data Structures in QlikView, Data Source Files, The QVD Primary Data Source, Secondary Data Files, Introduction to Scripting.
Topics - Syntax
Topics - Script Generation, Comments in the Script, Script Debugging.
Topics - Creating Tabs in the Script
Topics - The Table Viewer, The System Table, Document Properties: Tables page
Topics - 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.
Topics - 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.
Topics - Synthetic Key Tables, Circular References, Causes of Circular References, Check the Numbers.
Topics - 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.
Topics - Reference Materials, Data types in QlikView
Topics - User Friendly Design, Natural Human Behavior, Chart and Object Choices in QlikView, Import/Export Sheet and Document Layouts, APPENDIX: The Completed Script, QLIKVIEW_Developer
Topics - Troubleshooting, The Debugger
Topics - Mapping Quarters to the Orders table, Month Year, Cleaning up the table structure
Topics - Reading Cross Tables
Topics - Condition on a field in a table, Aggregating Data, Joining tables, Concatenation, Preceding Load on Preceding Load
Topics - Set Analysis, Dollar-Sign Expansion, AGGR Function
Topics - Link Tables and Concatenated Tables, Calculating net change within a field, Functions InDate, Data & DateIslands, Aggr(), Class(), Dynamic Aggregation, IntervalMatch
Topics - Performance Tuning, Best Practices for QlikView File Optimization, Creating Incremental Loads
Topics - 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
Topics - Custom Data, SAP Connector
Topics - Company Requirements, User Requirements, What configuration to choose?, QlikView Standalone, QlikView Server, QlikView Server & Publisher
Topics - License Overview, Server, Client Access Licenses, Publisher, Local Clients
Topics - 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
Topics - 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
Rithisha Information Systems Pvt.Ltd has been committed to providing the highest quality, needs-based training interventions to its clients, both locally and internationally, Rithisha is a renowned for superior training programs delivered by an enviable team of qualified, expert and highly experienced trainers in the area of Information Technology. Rithisha provides organizations and individuals with a complete and comprehensive suite of training offerings including online and classroom training's.
Register For Demo
Goals & Objectives
- Script level functions and chart level functions knowledge
- Design techniques and shortcuts about the less time
- se graphs, charts and pivot tables to represent your sales and business data
- You will be able to start building QlikView data models after completing this course