Hi,
You could try to:
1. Eliminate synthetic keys, if any.
2. Keep data transformations at a minimum, whereever possible.
3. Avoid using heavy calculations like nested if conditions, particularly if you are dealing with a large dataset unless really necessary.
4. Use QVDs to load data if and where applicable.
5.If the application is too big, split the application into multiple smaller apps.
Plus, you can check out the following threads for expert advice:
http://community.qlik.com/thread/18473
You can also download the attachment for QlikView optimization best practices from the following link:
http://community.qlik.com/docs/DOC-1882
Hope that helps.
Regards,
-Khaled.
