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

Summary

In this chapter, we learned about resolving data modeling challenges by loading a Crosstable and a link table. We also learned about the importance and creation of a master calendar.

Slowly changing dimensions are also handled using the IntervalMatch function.

Once done with all the data transformations, we loaded tables in QVDs, as reading data from QVDs is faster than reading from a database. We learned about optimized load to improve data load performance. This finished the scripting and data modeling in QlikView. This chapter also provided the best practices of data modeling that should be followed in order to create a better performing data model.

In upcoming chapters, we will learn about creating visualizations in QlikView using the ...

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