Hi ,
1. While loading large set of data you can implement the incremental load https://community.qlik.com/t5/Qlik-India/Incremental-loading-All-scenarios/gpm-p/1462918
2. Don't use conditions on the QVD's like where and exists
3. Don't add an extra column's to the QVD's.
4. Don't use Joins, concatenate and Keeps rather than Joins you can use Apply map()
5. Don't load data with select * from always give columns names instead of *
6. https://community.qlik.com/t5/Qlik-Design-Blog/Fact-Table-with-Mixed-Granularity/ba-p/1468238
But in short, a few steps I always take into consideration are:
1.- LOAD always from QVD files, and keep a file to pull from the database, do all needed transformations and store into the QVD will be loaded later. And LOAD only those fields you really need (pretty obvious, but "LOAD *" or "SELECT *" are usual). You don't need to have the Customer Name in both Invoices and Customer table, just linking "Invoices" to "Customers" through "Customer Code" will do.
2.- Use a fact table with all dimensions required trying to follow a star schema, instead of a snowflake schema (this is quite theoretical, but say that in your data souce you have a table with Customers, another one with Group of Customers, another one with Addresses of Customers, well, join them so you have one big "Customers" table with all required data). When concatenating to create this fact table, rename names so the final table has the same name and number of fields.
3.- Avoid IF() conditionals in any object expression, use instead set analysis.
4.- When linking one table to another by means of renaming a field in both alike (we could say these are the key fields), use a numeric value instead of a string (usually the AutoNumber() function will do).
5.- Note that QlikView is case sensitive, so when possible, set all your values to be in the same case.
6.- Use builtin actions instead of macros
7.- Create flag fields for those analysis or filters you want to use in the expressions, the simpler the expression the faster the chart is rendered.
8.- Take to the script all formatting, conversions, mapping... all complexity you can.
9.- Avoid RESIDENT loads. If needed, load twice from a QVD.
Again, most of the above are obvious and very vague, since your application and requirements will make life more complex. These are not MUSTs, rather than STRONGLYRECOMMENDED.
Hope this helps you
Vikas
Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
