Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Optimized and optimized QVD Load Situations?

Hi to all,

   I am New To Qlikview . SO I need Info.. about How to Optimized and optimized QVD Load Situations? Explain with Example?

4 Replies
its_anandrjs

Hi,

1. Remove unnecessary fields and keep only necessary fields.

2. Break data model into sub models and make groups for making different applications.

3. Load only minimum data which is necessary.

4. Make different stages for data model.

5. Make different level QVDs for the model and use them.

HTH

Thanks & Regards

ngulliver
Partner
Partner

Hi, Reddy.

Have a look at the blog on optimized loads. It describes how to optimize, what to look for and when you should use them.

http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/

Regards,

Neil

Not applicable
Author

Hi Anand,

   I Understood What you saying but any Example have to explain .......

ngulliver
Partner
Partner

Hi, Reddy,

You don't really need an example. Your QVD will be a table of data which you can amend. It can be from SAP, excel spreadsheet etc but won't contain any charts etc.This would have a store statement at the end

e.g.

STORE <table name> INTO (qvd);

You can then read this into a front end QVW (a full QlikView document) which would contain data from several sources, layout changes, charts, etc.

The advantage is that you can load the data in quicker if it has been converted into a .qvd

Regards,

Neil

p.s. I did post a link on this thread but it is stuck in 'moderation'. Have a look at www.quickintelligence.co.uk/qlikview-optimised-qvd-loads.