Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

primary keys ion QV

can I use PK in QV?

is there something similar?

Thanks

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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

View solution in original post

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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
Clever_Anjos
Employee
Employee

Useful reading: QIX - A Forgiving Engine