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 editor. Related subject matter should be on the same tab.
The first tab of the script should contain author and versioning information.
Author information and versioning is important for change control purposes.
Comment your code for better understanding...