Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

The quality of keys

Hi,

[I am using the German vrs. of QlikView]

As far as I know from my book, keys are categorized into "Perfect/ Primary/ Key" and

=> "Primary key" means that the key is unique, but the "Subset ratio" is less than 100%.

Now, I guess that translates to "Anteil der Werte" (the third value from the top displayed in that hover_over_window)

<=> Why do I, in one table I have just integrated into my data_model, a key with the quality "Key", but with a "subset ratio" of 100%? (The other value is also 100% in case that makes a difference)

Thanks a lot if anyone can clarify this!

Best regards,

DataNibbler

P.S.: The background is - there is an older version of this app where I have joined this table with another - but now I'm not sure about this: Joining with a non-unique key does not seem to be a good idea.

0 Replies