Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to decrease the QVF file size

I have a Qvf file of size 200mb I want to decrease the size of the qvf file to single digits can someone help me how do i do that, I have tried doing open app without data that completely decreases the size of qvf file but I want the some or the other data in qvf file

3 Replies
satheshreddy
Creator III
Creator III

Hi Nicholas,

comment the unwanted columns in Data.

Regards

Sathish

stiffi88
Partner - Contributor III
Partner - Contributor III

I case you have some tables you didn't need anymore drop them.

vlad_komarov
Partner - Specialist III
Partner - Specialist III

You can add the following to your data loading script:

 

let vLimitedLoad        = 'FIRST 3000';   // When not empty, this variable allows loading partial data

//let vLimitedLoad        = '';                    // Uncomment this statement for production use (full load)


FactsTemp:

$(vLimitedLoad)

LOAD

          *

FROM '$(TransformationsLibrary)/$(customerFile)’ (qvd);

The script will load only 3,000 records in the case above.

You should do it for the main Fact table only, usually....

VK