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?
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.