Qlikview

Information Density

Leave a comment

Information Density represents percentage of records that have not NULL values for a field.

Example:

country
code
Afghanistan AF
Albania
Algeria DZ

 

After loading the above records, go to the table viewer section (CTRL+T)

mouse hover on “country” field, you will see Information density is 100%

Now mouse hover on “code” field, you will see Information density is less than 100% i.e 67%

It means that, code field contains a null value in 2nd row that’s why it is showing Information density is 67%

Leave a comment

Design a site like this with WordPress.com
Get started