topic Understanding Data Compression in Qlik in App Development

Understanding Data Compression in Qlik

Aisha — Thu, 05 Dec 2024 05:22:20 GMT

I have a question regarding the compression of data. actually where this process happens? because after creating the qvd the size decreases but as per my understanding the QVD is ram image and there is no compression so the process of

Assigning symbols (integer) to string in the data while compressing in the backend where this process happens in QVD or QVF file?

Re: Understanding Data Compression in Qlik

marcus_sommer — Thu, 05 Dec 2024 15:18:25 GMT

There is no direct compression else it's just a more efficient way to store the data - only distinct values per field in n system-tables and with bit-stuffed pointers to the data-table(s). The more redundant the data are the better is the ratio against the raw-data. The logic within the applications (qvw/qvf) is the same as with the data-files (qvd).

Re: Understanding Data Compression in Qlik

Dana_Baldwin — Thu, 05 Dec 2024 18:52:54 GMT

Hi @Aisha

Please note the forum you have posted to is for the Data Integration product Enterprise Manager, used for managing multiple Replicate/Compose/Catalog servers. To reach your target audience, please consider posting your question here: https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense

Thanks,

Dana