Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kirankkk
Creator II
Creator II

Database table size vs Qlikview File size

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

2 Replies
tresesco
MVP
MVP

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
Employee
Employee

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