topic Re: How to reduce the Qlikview file size ? in QlikView

How to reduce the Qlikview file size ?

siva_boggarapu — Tue, 19 Jun 2012 07:58:54 GMT

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.

Re: How to reduce the Qlikview file size ?

hps — Tue, 19 Jun 2012 08:05:40 GMT

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

Re: How to reduce the Qlikview file size ?

Siva_Sankar — Wed, 20 Jun 2012 13:23:12 GMT

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.

Re: How to reduce the Qlikview file size ?

Wed, 20 Jun 2012 14:31:32 GMT

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

Re: How to reduce the Qlikview file size ?

rwunderlich — Wed, 20 Jun 2012 15:45:17 GMT

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

http://robwunderlich.com/downloads/

-Rob

Re: How to reduce the Qlikview file size ?

vincent_ardiet — Wed, 20 Jun 2012 16:09:59 GMT

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