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

This chapter covered the basics of QlikView scripting and data loads. You were able to load data from a relational database and flat files to get started on creating a data model. This chapter also covered the data transformations required to find a sales person, ProductLine grouping, and calculated fields in the tables. As more tables are loaded, synthetic and circular loops are produced. By learning to resolve synthetic keys and loops, you are on your way to producing an optimized data model.

In the next chapter, you will learn how to reduce the number of tables and joins in your data model by using mapping load and applymap functions. You will also learn about different kind of joins in QlikView.

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