How to reduce the Qlikview file size ?

[siva_boggarapu]

Hello there,

I have one Qlikview report. The Size of the file 900MB. I want to reduce the flle size. Because while opening it is taking more time. Even I am unable  to crete charts.

Can anyone help me how decrease the file size or Optimization techniques?

I have been facing this problem since one week.

Best,

Siva.

[hps]

Hi Siva,

Take a look at the scalability group : http://community.qlik.com/groups/qlikview-scalability?view=discussions&start=0

You should also go through the QuickTips posted by Lars Skage:

http://community.qlik.com/people/lse?view=overview

Data size can alleviated by loading fewer fields, transforming the data smartly. Do you need information by the second or is by day enough? Etc..

Regards,

Hampus

[Siva_Sankar]

In Qlikview, Application is automaitcally highly compressed while saving it.  which is available in user settings -> save -> compression and there it will be high, normal , low.  by default, it is already high. So, it is already compressed upto the max possible limits.

[#4]

Hi,

1. Understand the business logics and requirements to create the dashboard.

2. Fetch only those fields which required for analysis (i.e) when we fetch the data from table may be it will be having 15 fields, to create the dashboard we need only 7 fields and data of it, remaining 8 fields of data is not used at this situation we dont need of those fields and data for it, so in this case we can comment on those 8 fields.

3. Do limited load of data, for eg this will load first 1000 rows of data only, where you can do the design of dashboard and after finishing the dashboard you can do the full load of data;

First 1000

Load *

Table Name;

Regards,

Prasath

[rwunderlich]

If you need help identifying unused fields, download the DocumentAnalyzer  tool from

http://robwunderlich.com/downloads/

-Rob

[vincent_ardiet]

Hi,

Perhaps your application is taking time in order to compute charts not for loading the data ?

Try to avoid the use of IF statement in your dimensions or expressions and use set analysis instead.

Try to avoid count([MyKey]) but create counter field in your table (=1) and then use sum([Counter]).

You can test if it's due to the data or the charts by making a selection before saving the document. If it's quicker to open it when a selection is made, the amount of data is not (totaly) involved.

Regards,

Vincent