qvw size?

[#1]

I have q qvds like  30mb ,4GB,  i have loaded my qvds and developed dashboard when it come to size of qvw  like  

400 mb     see when we compare to size of qvds it is very less ? how it is happening ? what is the concept behind ?

as of my point of view  i feel data is storing in ram not in dash board? am i right?

[jagan]

Hi,

Qlikview file not only stores the QVD data, but it also stores the chart definitions, sheet definitions, data model and associations, so that is why qlikview file size is usually more than that of QVD file size.

Regards,

Jagan.

[#3]

in my case qvw size is small when it comapred to qvds size ?

[jagan]

HI,

You have loaded all the columns and records into QVW file?

Regards,

Jagan.

[JonnyPoole · Accepted solution]

I think you are asking why the QVW is less than the QVD size ?

The primary reason is that by default, all QVWs are compressed whereas QVDs are not. Compression can reduce size into the 90's% .... but it all depends on how unique each record of data is to begin with.

So if you had a 30MB and a 4GB QVD , your QVW of 400MB represents ~90% compression.

Note that when you open the QVW in RAM, it will expand somewhat. Then if there is RAM left on the machine, Qlik will use that to store the aggregated numbers for the UI that result from the user requests .

[Clever_Anjos]

QVW can be compressed by defaul, please check at Document Properties if your qvw is compressed