topic Re: Shrink ratio in QVD and QVW files in QlikView

Shrink ratio in QVD and QVW files

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hi When we extract data from Excel sheet of 5 GB and store it into QVD. What would be the size of the QVD, what is the the shrinkage ratio. In what format the data present in the QVD is stored. How the shrinking of the takes place.

Re: Shrink ratio in QVD and QVW files

petter — Tue, 02 Jun 2015 20:14:36 GMT

You should read Rob Wunderlich's article about Document Compression on his qlikviewcookbook . com site.

Just Google:

Rob Wunderlich document compression

And you find the link at the top of the search results.

Re: Shrink ratio in QVD and QVW files

Anonymous — Tue, 02 Jun 2015 20:16:19 GMT

sure Petter will read that and update the discussion.

Re: Shrink ratio in QVD and QVW files

petter — Tue, 02 Jun 2015 20:26:02 GMT

This article too by Henric Cronström is very relevant to the topic too:

Symbol Tables and Bit-Stuffed Pointers‌

It touches the very core of the "compression" techniques used in QlikView and Qlik Sense. The de-duplication that is done is definitely a compression technique.

Re: Shrink ratio in QVD and QVW files

pratap6699 — Wed, 03 Jun 2015 05:50:52 GMT

it compressed on QVD based on fields and records...i think your source file is 5GB QVD can compress data 10 to 100 % so it should be 1GB of QVD

Re: Shrink ratio in QVD and QVW files

petter — Wed, 03 Jun 2015 05:53:34 GMT

unfortunately QlikView or Qlik Sense cant compress it 100%. But it would have been a killer feature though

Re: Shrink ratio in QVD and QVW files

jonathandienst — Wed, 03 Jun 2015 06:05:09 GMT

Remember that Excel stored in .xlsx format is also compressed, so a QVD created from the Excel file may not be significantly smaller - it will depend on the values in the data sheet. The older .xls format is not compressed.

Re: Shrink ratio in QVD and QVW files

Anonymous — Wed, 03 Jun 2015 12:46:00 GMT

Thank you Jonathan... that is useful info. I did not know that.

Re: Shrink ratio in QVD and QVW files

Anonymous — Wed, 03 Jun 2015 12:46:43 GMT

sure will go through the topic and get back to you.. Thank you for your quick response...

Re: Shrink ratio in QVD and QVW files

Anonymous — Wed, 03 Jun 2015 12:47:47 GMT

Thank you for your response. I will do a test run and check it. Is there any tech brief or tech note or a discussion with explains how that is done internally. Thanks for your help.