Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

select primary key

hello community,

is it possible, to select a field in the table, which should be used as a primary key ?

of course, the field has to be qualified for this. but QV chooses the key by itself and sometimes seems generates a hidden primary key.

in SQL, [timestamp as PrimaryKey] allows to chose which filed represents the key.

I havent found a hint on if this is possible, wether in the "reference guide" nor in the community.

thanks

5 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Why you looking for primary key here?You came across any issue because of not having primary key?

     As of me creating primary key is not possible.

Celambarasan

Not applicable
Author

Qlikview choose the wrong field of the table as primary key.

im looking for an option to choos the key yourself, overriding the automatic function of qlikview.

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     You mean the tables joins itself using the field names are in common?

Celambarasan

Not applicable
Author

Exactly, but there are 3 fields, with the same name in both tables.

I want to choose, which field should be used AS KEY.

Fieldnames cant be changed, because the relations are allready in use.

Not applicable
Author

Hi,

I have the same problem, did you get it fixed? Any Tips for me?

Thanks,