topic Re: How to reduce QVW file size without loosing data in QlikView

How to reduce QVW file size without loosing data

suhaskharat — Fri, 15 Jan 2016 11:38:32 GMT

Hi all i have a QVW file of 507 mb and i have to reduce size of it without loosing data so i created another copy of it and took the binary of first one as i don't have its data model and tried to drop unused fields and tables but it reduced to 483 mb. Is there any other way to reduce the application size?

Re: How to reduce QVW file size without loosing data

Fri, 15 Jan 2016 17:05:42 GMT

without knowing the data model and how it was created, it is hard to make suggestions

below is a thread regarding a similar issue that was resolved with the data model

Trick to Reduce QVW File Size

Google

you can also do a search on the community for 'reduce qvw size' for other ideas as well

Re: How to reduce QVW file size without loosing data

miguelbraga — Fri, 15 Jan 2016 17:21:33 GMT

Please see these 3 posts:

Document Compression | Qlikview Cookbook

QlikView Maven: Reducing Report Size

Qlikview data compression: From source to QVW to QVD‌

Regards,

Re: How to reduce QVW file size without loosing data

miguelbraga — Fri, 15 Jan 2016 17:22:44 GMT

Or even these:

QlikView Addict: QlikView Binary Loads

Re: How to reduce QVW file size without loosing data

miguelbraga — Fri, 15 Jan 2016 17:25:31 GMT

Read these article:

http://www.datamind.co.il/image/users/174172/ftp/my_files/PDF/BI-WP-QlikView-Scalability-Overview-EN.pdf

Re: How to reduce QVW file size without loosing data

Anonymous — Fri, 15 Jan 2016 17:36:36 GMT

This really is a balancing act. Qlik works optimally with large fact tables and less hops between data. If you are willing to sacrifice performance, you could normalize your data model and reduce the columns in your large fact tables. We have a fact table with 90 million rows, so reducing even 1 column would make a big difference.

Curious, why do you think your app size it too big? Is it slow?

Maybe you just need more memory in your desktop. We have 32 GB of ram and the difference between performance with 16 and 32 GB is night and day.

Re: How to reduce QVW file size without loosing data

Anonymous — Fri, 15 Jan 2016 17:47:57 GMT

I found this old thread with some really practical advice from Qlik Community Legend John Witherspoon. I am making note of this decision tree for future reference.

left join VS keeping table seperate (normalized vs denormalized)