Database table size vs Qlikview File size

[Anonymous]

May I know any formula or technique to find equivalent QVW size from Database table size.

[tresesco]

qvw size majorly depends on:

• compression technique you choose (Settings->Document properties->General ...compression)
• uniqueness of data (more repeated the values {data/metadata}, smaller the size and vice-versa)

If you want to learn it in depth, read: Symbol Tables and Bit-Stuffed Pointers

[hic]

The technique is empirical: Load the data and see what you get... The size of the file is fairly linear to the data amount, so you can also load a subset of the data and extrapolate to make an intelligent guess.

Tresesco's answer above is absolutely correct. In addition, the database may or may not contain large amounts of indexes, so the same table may in a database sometimes use a lot of memory, sometimes a lot less.

HIC