information density and subset ratio?

[#1]

Hi ,

when i keep cursor on datamodel  for few fields i can see both information density and  subsetratio , but for few fields i can see only information density?

why?

[maxgro]

subset ratio is for field in more than 1 tables (there is no subset ratio for field in 1 table only)

definition of subset ratio from qlik online help

Subset ratio is the number of distinct values of this field found in this table as compared to the total number of distinct values of this field (that is other tables as well).

[#3]

Hi Manoj,

As per my understanding, information density and subset ratio is shown for key field (which is common in atleast two tables)

fields which are showing only information density will not be connected to other tables.

[ashfaq_haseeb]

Hi Manoj,

For better understanding check the below blog post by henric.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/18/the-table-viewer

Regards

ASHFAQ