2 Replies Latest reply: Nov 17, 2016 10:05 AM by Dave Wakefield RSS

    qvf size and how do I reduce it on an export?

    Dave Wakefield

      I have an App in QlikSense 3.0.2 which loads approx 40m records using

      LOAD <fields> from [<connection>/xxx.qvd] (qvd);

       

      After the App has saved, in the QMC Apps list, if I add 'File size(MB)' column from the column selector, it shows the App as 350Mb. However, when I do 'More actions / Export', the download size says 2.8Gb.

       

      All I really wanted from the export is to back up the App load script and sheet designs, so in an attempt to reduce that 2.8Gb size, I re-ran a number of versions of the load script, saving the App & trying an Export after each one. The download size stayed as 2.8Gb after each one though.


      I tried

                Test:

                LOAD <fields> from [<connection>/xxx.qvd] (qvd) where 1<>1;

       

      then

                Test:

                First 1 LOAD <fields> from [<connection>/xxx.qvd] (qvd);


      then

                Test:

                First 1 LOAD <fields> from [<connection>/xxx.qvd] (qvd);

                Drop table Test;

       

      Q1. What do the 350Mb & 2.8Gb sizes actually represent. Is the 350Mb the App including data in compressed format, but the data gets uncompressed on Export?


      Q2. How can the App export size be reduced?