O'Reilly logo

QlikView Essentials by Chandraish Sinha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4. Data Modeling Challenges

In creating a data model, you will come across challenges in terms of different formats of data, loading multiple fact tables, and performance issues. There are techniques to resolve these challenges.

In this chapter we shall:

  • Learn about loading a Crosstable
  • Learn about the Autonumber function
  • Learn about creating a link table to load multiple fact tables
  • Learn about variable overview
  • Learn about creating a master calendar
  • Handle SCD using IntervalMatch
  • Store and read data from QVDs (QlikView data files)
  • Learn about optimized load
  • Discuss best practices for data modeling

Crosstable essentials

In your downloaded folder, look at EmployeeSalesTarget.xls. This file is located in C:\QlikViewEssentials\Data.

Some of the properties ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required