handling qvw

[SunilChauhan]

Hi,

after doing aptimization and all we have left with 10GB qvw.

is there any way we can handle this.

please assume that configuration is not a problem.

[MayilVahanan]

Hi

Please refer

*** 6 Weeks in to QV Development, 30 Million Records QV Document and Help Needed!!! ****

[jagan]

Hi,

How many records and columns you have in your tables?  If you have millions of records then try to optimize like this

- Remove unused columns in charts from your datamodel

- Remove unused rows from your datamodel - i.e., If users wants to analyse only last 3 years data then load only last 3 years data, this will reduce the size, check with your users.

- Truncate time part in your date fields if you are not using,  Date(Floor(DateField)) this will reduce some bytes of data in every record.

- If possible try to use group by to reduce the records.

- If you have key fields as strings then convert it to numbers by using AutoNumber()

Hope this steps helps you.

Regards,

Jagan.

[SunilChauhan]

Thanks for your reply

We have done all this after that i have left with 10 gb data

[jagan]

Hi Chauhan,

Qlikview automatically stores the data in compressed format, so there is nothing to do, if you need all the data then you will not able able to reduce the file size.

Try loading data for 1 year or 1 month and check the file size, if size reduced then define the limit that is what we can do.

Regards,

Jagan.

[avinashelite]

Hi Chauhan,

Try to break your qvw file into sub parts like 10GB file data to year or region  wise qvd's and after that re-union all the qvd's this will reduce the size of the file.

Regards,

@vi