QlikView App Dev

[#1]

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

[jagan]

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.

[#3]

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]

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]

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]

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