How does QlikView internally store each data field that is loaded into the data model?

[#1]

Hello all the question is in the topic

How does QlikView internally store each data field that is loaded into the data model?

Thank you in advance

[Clever_Anjos · Accepted solution]

Basically QV calculates distinct values for each field, than creates a bitmap representation for each value.

Then creates two kind of tables

Symbol Tables (every distinct value and its bitmap representation)

Data Tables with "pointers" to Symbol tables

Further reading: Symbol Tables and Bit-Stuffed Pointers

[harsh44_bhatia]

The Post mentioned by Clever by HIC is really good, also i would suggest you to look into functions such as exists(), fieldvalue(), etc. whcih works on the concept of symbol tables. this will help you in grasping QV scripting much better