Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
waszcma1
Partner - Creator II
Partner - Creator II

Density in data model viewer

Hi 

I am trying to optimize very slow application and what I have discover that in the fact table there are fields which have very low Density

 

  • Information Density is the number of records that have values (i.e. not NULL) in this field as compared to the total number of records in the table.

i.e.:

waszcma1_0-1628187292820.png

so it means that in ~26 mln records 48,4% have non null-value for that field? 

 

 

 

 

 

1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

No, it means that there are 26410575 non null values that are making up the 48,4%

So, total rows in table are ~26 mln in ~55 mln rows in table

View solution in original post

1 Reply
Lisa_P
Employee
Employee

No, it means that there are 26410575 non null values that are making up the 48,4%

So, total rows in table are ~26 mln in ~55 mln rows in table