Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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