Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
juanvg1972
New Contributor III

primary keys ion QV

can I use PK in QV?

is there something similar?

Thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: primary keys ion QV

A QV model is not a normal form database and does not use keys in the same way. You can certainly load PK values into QV, but if they are well formed 'no-information/logic free' keys, you may not need them in QV.

A key in QV is a field that exists in more than one table and is the basis of the association between the tables. A key may be designated as a "perfect key" in the table if there is one unique value of the key field for each row in the table and that is conceptually similar to a PK in a normal form database.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies
MVP
MVP

Re: primary keys ion QV

A QV model is not a normal form database and does not use keys in the same way. You can certainly load PK values into QV, but if they are well formed 'no-information/logic free' keys, you may not need them in QV.

A key in QV is a field that exists in more than one table and is the basis of the association between the tables. A key may be designated as a "perfect key" in the table if there is one unique value of the key field for each row in the table and that is conceptually similar to a PK in a normal form database.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Employee
Employee

Re: primary keys ion QV

Useful reading: QIX - A Forgiving Engine

Community Browser