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

Best practices of data modeling

In the previous chapters, we learned how to create a data model in QlikView. While creating a data model, it is always recommended to follow the best practices so that the data model is reusable and performs better.

The following best practices of data modeling will ensure a robust data model. It will also recap what we learned so far:

  • Associations: In QlikView, associations are created based on common field names between the two tables. Associations should be created based on the business context between the tables. To create or break associations, table columns can be renamed. Wrong associations will result in wrong outputs.
  • Organize your script. Data load scripts should be organized by creating tabs in the script ...

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