Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
you can also do a search on the community for 'reduce qvw size' for other ideas as well
Please see these 3 posts:
Document Compression | Qlikview Cookbook
QlikView Maven: Reducing Report Size
Qlikview data compression: From source to QVW to QVD
Regards,
MB
Or even these:
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.
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)