major areas in optimizing Qlikview application

[#1]

can any body expain major areas generally consider while optimising QVW

[whiteline]

Hi.

The areas are relative to the goals:

- performance

- memory usage

- user experience

- data check complexity

- support complexity

- scalability

- real-time data

...

[Siva_Sankar]

Mahesh,

Optimization can be done in several ways at different stages.

1. In Data modeling,

2. Scripting

3. Expression

4. UI Level

5.Server Side

Find the attached documents for more information about optimizing the qlikview applications. Will be helpful.

Regards.

Siva

[#4]

can u please attach the Doc

[Siva_Sankar]

Document is already attached in my reply above,Mahesh.

Regards.

Siva

[jagan · Accepted solution]

Hi Mahesh,

The major areas in Optimizing Dashboard is

Good Data Model

Sufficient RAM

Expressions (Try to avoid Aggr, Calculated Dimensions, etc)

Limited Calculations in Expressions

Don't display huge data in Straight, Pivot and Table boxes (Restrict user to select filters to reduce data to be displayed in table)

Qlikview file size (Load only dimensions and data which are used in Dashboard)

etc.

Regards,

Jagan.

[sujeetsingh]

Go to this

http://community.qlik.com/docs/DOC-4556

[ngulliver]

Hi,

There is a useful blog on optimisation:

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

Regards,

Neil