Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
SunilChauhan
Champion
Champion

handling qvw

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.

Sunil Chauhan
5 Replies
MayilVahanan

Hi

Please refer

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
jagan
Luminary Alumni
Luminary Alumni

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
Champion
Champion
Author

Thanks for your reply

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

Sunil Chauhan
jagan
Luminary Alumni
Luminary Alumni

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