# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean:
Not applicable

## What does "Subset Ratio" means? for a key field in table viewer?

Hi,

Can some one explain What does "Subset Ratio" means for a key field when we hover in table viewer? (Screenshot is attached)

What are the concequences on the report if this ratio is

=100% or

>100% or

<100%

Looking forward to hearing.

Thanks,

TA

5 Replies
Luminary Alumni

HI,

Subset Ratio tells you the percentage of items exists in the current table by comparing with the overall distinct valus of that field.

Suppose Product table has 100 productIDs, and order table has only 50 productIDs in ProductID column then the Subset Ratio for Order table is 50% (50/100).

Subset Ratio for Order table is 100% (100/100).

Note : Subset Ratio don't exceeds 100%.

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

Thanks Jagan.

Can you answer the second part of my question as well?

"

What are the concequences on the report if this ratio is

=100% or

>100% or

<100%

"

Luminary Alumni

Hi,

SubSet Ratio won't exceed 100%.

Suppose Product table has 100 productIDs, and order table has only 50 productIDs in ProductID column.  Mean that 50 products are not sold yet.

If the ratio is 100%, then all the products are sold atleast once.

Hope it helps you.

Regards,

Jagan.

Contributor II

Hi,

subset ratio is the number of unique occurences in the table in question as compared to the total number of unique occurences in all tables. See the example below there are five unique occurences in the field F1 (numbers 1-5). The subset ratio in table A is 60% (3/5, ie 3 unique occurences as compared to 4 rows in the table). In table B the subset ratio will be 80% (numbers 1, 2, 4 and 5 as compared to the total the numbers 1-5, ie 4/5).

Regards,

Niklas

A:
F1, F2
1, A
2, B
3, C
3, Cbis
];

B:
F1, F3
1, I
2, II
4,  IV
5, V
];

Specialist

hello Jagan,