Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
As per the help when you export the QVF all the relevant contents like photo, images etc also gets exported.
https://help.qlik.com/en-US/sense/3.0/Subsystems/ManagementConsole/Content/export-apps.htm
So just check what is happening in your case.
Regards,
Kaushik Solanki
Thanks - I was aware of that, but my App doesn't have any images etc. It's just got Pivots, Tables, Filters, Graphs