cancel
Showing results for
Did you mean:
Not applicable

## what is Density and Subset Ratio? How to View that?

Hi Folks,

@SUb2u

4 Replies
Master III

Information density of the field, which indicates the percentage of rows that contain a non-null value.

Subset ratio, which shows the percentage of all distinct values for a field in the table compared to all the distinct values for that field in the entire data model. It is only relevant for key fields since they are present in multiple tables and do not all share the same value. Subset ratios can be used to easily spot problems in key field associations. For example, when the combined total of subset ratios for multiple tables is 100 percent, this may indicate that there are no matching keys between these tables.

Partner - Specialist

Just hover the mouse where your association,its shows information density and subset ratio.

Regards,

MVP

Hi

Information density of the field, which indicates the percentage of rows that contain a non-null value

Subset ratio, which shows the percentage of all distinct values for a field in the

table compared to all the distinct values for that field in the entire data model. It is

only relevant for key fields since they are present in multiple tables and do not all

share the same value.

Subset ratios can be used to easily spot problems in key field

associations.

For example, when the combined total of subset ratios for multiple

tables is 100 percent, this may indicate that there are no matching keys between

these tables.

REF: QlikView 11 For Developers..

Let me give you simple example

Sales:

[

Customer, Sales

A, 100

B, 200

D, 300

];

Customer:

[

Customer

A

B

C

D

];

If you write above sample script and will check the Table (CTRL + T), you will find two tables.

Sales and Customers

On Sales Table, if you hover the mouse on Customer field, you can see the Subset Ratio is 75% because there is not sales data for Customer C.

Now if you change the script for table Customer like below..

Customer:

[

Customer

A

B

C

D

]

Where Exists (Customer);

If will not load the Customer C as there are no sales data for the same.

Now check the Subset Ratio. It will be 100%.

If subset ratio is less than 100%, the key is called as Primary Key

but for 100% it is called as Perfect Key.

MVP

how to  view?

table viewer

The Table Viewer

what is ...?

from QlikView help

When hovering with the cursor above one of the fields in a table, a tool tip pops up with information about the content of this field:

• 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.
• Subset atio 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).
Community Browser