Which database? The source database? It can have lots of primary keys. Every table can have a primary key. Or do you mean the in-memory database of the Qlik Sense app? That doesn't have primary keys. It will have fields marked as keys which means those fields are used to associate tables with each other.
If the table doesn't have any primary key in source database, we can combine more than one field and make it primary key.
Check the source table data . Hope this will help you. Thank you.
No, it has nothing to do with how it is tagged in the database.
The Qlik engine simply looks at some of the properties of the key.
- A "Perfect Key" has no duplicates and is complete: It contains all the values of the field.
- A "Primary Key" has no duplicates, but is incomplete. Other values may exist in other tables.
- A "Key" has duplicates.
This classification is visible in different ways in QlikView and in Qlik Sense: