How do you optimized QlikView application?What Tools are used and where do you start?

[#1]

hi,

Anyone can give the answer for this question.

Thanks in advance

Hita

[maleksafa]

first check your data model, see if you can make it a perfect star schema. use autonumber to link between tables instead of text fields.

use the document analyzer (you can download it from the community just search for document analyzer) and it will tell you what are the fields in your schema that you are not using and therefore you can drop them to reduce the size of your document.

try not using calculated dimensions and complex expression and see if you can do them in the script instead.

[its_anandrjs]

Hi,

For Optimization we can optimized the QVD which is used in the QVW files in the backend. For QVW optimization i believe not use any tools we can manually remove unwanted fields form data model or comment it, remove most complex logics from the load script or create it with the simple way because it will take long time for loading. If using large data base file try to create the incremental load for the QVD or load latest data only.

Regards
Anand