topic Re: How does QlikView internally store each data field that is loaded into the data model? in QlikView https://community.qlik.com/t5/QlikView/How-does-QlikView-internally-store-each-data-field-that-is/m-p/1011952#M978050 <HTML><HEAD></HEAD><BODY><P>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&nbsp; </P></BODY></HTML> Thu, 27 Aug 2015 20:36:55 GMT harsh44_bhatia 2015-08-27T20:36:55Z How does QlikView internally store each data field that is loaded into the data model? https://community.qlik.com/t5/QlikView/How-does-QlikView-internally-store-each-data-field-that-is/m-p/1011950#M978048 <HTML><HEAD></HEAD><BODY><P>Hello all the question is in the topic</P><P><SPAN style="color: #000000; font-family: Arial; font-size: 16px; font-weight: bold;">How does QlikView internally store each data field that is loaded into the data model?</SPAN></P><P><SPAN style="color: #000000; font-family: Arial; font-size: 16px; font-weight: bold;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: Arial; font-size: 16px; font-weight: bold;">Thank you in advance<BR /></SPAN></P></BODY></HTML> Thu, 27 Aug 2015 20:16:34 GMT https://community.qlik.com/t5/QlikView/How-does-QlikView-internally-store-each-data-field-that-is/m-p/1011950#M978048 2015-08-27T20:16:34Z Re: How does QlikView internally store each data field that is loaded into the data model? https://community.qlik.com/t5/QlikView/How-does-QlikView-internally-store-each-data-field-that-is/m-p/1011951#M978049 <HTML><HEAD></HEAD><BODY><P>Basically QV calculates distinct values for each field, than creates a bitmap representation for each value.</P><P>Then creates two kind of tables</P><P>Symbol Tables (every distinct value and its bitmap representation)</P><P>Data Tables with "pointers" to Symbol tables</P><P>Further reading: <A href="https://community.qlik.com/qlik-blogpost/2848">Symbol Tables and Bit-Stuffed Pointers</A></P></BODY></HTML> Thu, 27 Aug 2015 20:20:59 GMT https://community.qlik.com/t5/QlikView/How-does-QlikView-internally-store-each-data-field-that-is/m-p/1011951#M978049 Clever_Anjos 2015-08-27T20:20:59Z Re: How does QlikView internally store each data field that is loaded into the data model? https://community.qlik.com/t5/QlikView/How-does-QlikView-internally-store-each-data-field-that-is/m-p/1011952#M978050 <HTML><HEAD></HEAD><BODY><P>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&nbsp; </P></BODY></HTML> Thu, 27 Aug 2015 20:36:55 GMT https://community.qlik.com/t5/QlikView/How-does-QlikView-internally-store-each-data-field-that-is/m-p/1011952#M978050 harsh44_bhatia 2015-08-27T20:36:55Z