Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New Contributor III

qlikvew data upper limit

Hi everyone,

I want to know  the qv data upper limit. Of cource ,I know it depends on RAM、CpU and so on. But what happens when the data size is bigger than RAM?  In the other world, there exsits the proportion between RAM 、SIZE 、lines and so on. when RAM is 32G, then the upper limit? when RAM is 64,then?

Another question, if I use the SSD, what will happens and big influence?

My clients need to know these .So I need a document , please help. Thanks.

2 Replies
Valued Contributor

Re: qlikvew data upper limit


The application will simply not run and would crash if the data size is larger than that of the RAM size .

There is no impact of use of SSD except for first time data pull into RAM , but after the application is loaded with data there will be no impact when users perform analysis or make any selections.

PS : You can look into direct discovery for very large data volumes.


Nadeem Shaikh

MVP & Luminary
MVP & Luminary

Re: qlikvew data upper limit

If the size of your qlikview application is bigger than your RAM it won't work. Even it's a bit lesser it won't make much sense because you need further RAM to calculate thing and to cache these calculations. The important point here is the (uncompressed) size of the qvw and not the size of your raw-data. The reason is that qlik used a quite effective way of storing the data which often results in compression-rates of 80-90% - essentially depending on the cardinality of the fields.

There is no practically way to pre-calculate the needed RAM consumption only with the raw-data size or the number of records - it will always depend on the data itself and how the datamodel is designed and the RAM consumption is especially not linear with the amount of data.

- Marcus