Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead 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
jagan
Luminary Alumni
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%.

Check help file for more info.

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%

"

jagan
Luminary Alumni
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.

niklas_hedlund
Contributor II
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:
LOAD * INLINE [
    F1, F2
    1, A
    2, B
    3, C
    3, Cbis
];

B:
LOAD * INLINE [
    F1, F3
    1, I
    2, II
    4,  IV
    5, V
];

jim_chan
Specialist
Specialist

hello Jagan,

i was reading this thread. you were giving this example:

"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)."

- So, subset ratio for ProductID in Order tabke is 50% ?right?

- then the next one u said "Subset Ratio for Order table is 100% (100/100)." , so just to clarify...which is which?

Rgds

Jim