topic Re: What does "Subset Ratio" means? for a key field in table viewer? in QlikView

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

Fri, 26 Apr 2013 14:17:31 GMT

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,

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

jagan — Fri, 26 Apr 2013 14:26:31 GMT

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.

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

Fri, 26 Apr 2013 15:36:07 GMT

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%

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

jagan — Sat, 27 Apr 2013 05:29:09 GMT

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.

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

niklas_hedlund — Wed, 08 May 2013 09:53:09 GMT

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
];

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

jim_chan — Tue, 13 Sep 2016 11:42:48 GMT

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