Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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