topic Re: Data model keys in QlikView

Data model keys

Wed, 25 Nov 2020 16:16:04 GMT

Hi folks!

This is a first post from a newbie so please be gentle!

I would like to pick your brain on keys in a QlikView data model.

Primary key - is unique for each record in a table. Subset ratio is less than 100% always?

Perfect Key - is a primary key with subset ratio of 100% always?

Key - is non-unique with a subset ratio of 100% or less?

I can't currently think of any more keys. Any help would be much appreciated.

Nish

Re: Data model keys

maheshkuttappa — Tue, 02 Aug 2016 23:04:04 GMT

You could refer below links for details ,

[Perfect Key]?

What is Perfect Key & Information Density?

Re: Data model keys

Wed, 03 Aug 2016 08:55:36 GMT

Hi Mahesh,

Thanks for your reply.

I'm familiar with the details on the links you have provided. Basically, I am looking for a yes/no type answer to my questions to re-assure that my understanding of this concept is legit - that's all.

Nish