topic Re: perfect key in Water Cooler

perfect key

Tue, 16 Jul 2013 15:06:18 GMT

1.what do you mean by perfect key and primary key in qlikview?

2.what do you mean by first stored value/

Re: perfect key

jagan — Tue, 16 Jul 2013 15:17:32 GMT

Hi Venkat,

Check this

http://community.qlik.com/thread/55769

Hope it helps you.

Regards,

Jagan.

Re: perfect key

Tue, 16 Jul 2013 15:22:39 GMT

Thank you jagan

Re: perfect key

jagan — Wed, 17 Jul 2013 15:29:00 GMT

Hi Venkat,

If my post helps you in answering your question please close this discussion by giving Correct Answer to my post, so that it helps others in finding answers similar to this.

Regards,

Jagan.

Re: perfect key

Tue, 04 Nov 2014 04:03:19 GMT

From the Book QlikView 11 for Developers:

"The name of the field. Optionally, if the field is a key field, a qualifier is shown enclosed in square brackets. This qualifier indicates the following levels of key quality:

[Perfect Key] indicates that every row contains a key value, and that all of these key values are unique. At the same time, the field's subset ratio is 100 percent. This qualifier should be seen in dimension tables, where every key should uniquely identify a single record.

[Primary Key] indicates that all key values are unique, but not every row contains a key value or the field's subset ratio is less than 100 percent

[Key] indicates that the key is not unique. This qualifier is usually seen in fact tables, where the same dimension value may be associated with many different facts."