There are certain conventions and limitations you need to be aware of when working with QlikView. For example: the upper limit for data tables and fields as well as maximum amount of loaded data in QlikView.
Guidelines for amount of loaded data
The amount of data that can be loaded into QlikView is primarily limited by the amount of primary memory of the computer.
Upper limits for data tables and fields
Be aware when building very large documents that a QlikView document cannot have more than 2,147,483,648 distinct values in one field.
The number of fields and data tables as well as the number of table cells and table rows that can be loaded, is limited only by RAM.
Recommended limit for load script sections
The recommended maximum number of characters to be used per load script section is 50,000 characters.