Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dselgo_eidex
Partner - Creator III
Partner - Creator III

Does Qlik Sense create internal index tables?

Hello, I was recently tasked with preparing a presentation to our Data Warehouse team to cover some of the basics of Qlik Sense so that they understand the needs on the visualization end. One important topic I am trying to cover in this presentation is our data model and the features that Qlik Sense employs (e.g. associative data model, loading app into memory, etc.).

One of the things that I was going to talk about is how Qlik Sense internally indexes all unique values of a field to reduce duplication of memory. In my understanding, at the end of the data load every field has an internal index field created for unique values. For instance, say you have a table that contains demographic data for people:

PersonEthnicityGender
AWhiteMale
BWhiteFemale
CAfrican AmericanFemale
DAsianMale
EWhiteFemale


At the end of the load script, an index table gets created for each field

Person:

IndexValue
1A
2B
3C
4D
5E


Ethnicity
:

IndexValue
1White
2African American
3Asian


Gender
:

IndexValue
1Male
2Female


And then the original table just becomes

PersonEthnicityGender
111
212
322
431
512


But as I was preparing this, I realized that I don't remember how I came across this knowledge. I've tried searching for any documentation on this, but I can't find any and now I am uncertain if this is how Qlik Sense actually works.

Can anyone confirm this or point me towards some documentation on the subject?

Labels (6)
1 Solution

Accepted Solutions
3 Replies
lorenzoconforti
Specialist II
Specialist II

dselgo_eidex
Partner - Creator III
Partner - Creator III
Author

This is the article I have been looking for my entire life! Lol, this is exactly what I needed. Thank you!