Become QlikView Developer from Scratch

Create a new QlikView project, establish a database connection, and configure data loading by using relational and non-relational sources, variables, and a select statement with data preview.

Create a new QlikView app, connect to the Northwind database, load the orders and order details tables, define the order id key, and verify the load with a reload log.

Learn to load data from an Excel file into a multi table data model, create associations, and manage system fields and variables with absolute or relative paths.

Resolve circular loops and synthetic keys by rewiring the data model, create proper keys to link customers, employees, and suppliers, and reload to verify correct relationships.

Create data in QlikView scripts with resident load to generate counters for active customers and orders from the orders table, using customer IDs and sales employee data.

Create a master calendar in QlikView by extracting the minimum and maximum dates, generating a date range, and linking year, month, day, quarter, and week fields to the data model.

Improve the master calendar script by using field value functions to get min and max dates from the order date field, then build a calDate calendar with a while loop.

Learn how to create and use mapping tables in QlikView, apply preceding load to compute margins, and map shipper and product data to enrich orders and order details.

Explore loading cross-tables to resolve granularity differences across years, using a three-parameter approach—year field, data value field, and a number—and examine how data-model levels affect analysis.

Load data from a cross table by editing the script to load the forecast table, map header fields, and create a composite key by concatenating product and employee IDs.

Explore link tables to resolve cross-table granularity issues, establish correct associations between the fact table and dimension data using keys like employee id, and ensure distinct linked records.

Master set analysis in QlikView by building filters, excluding beverages, ignoring country fields, and using dollar sign expansion and year minus one to compare sales across categories.