Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

select primary key

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

select primary key

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
Not applicable

select primary key

Hi,

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

Celambarasan

Not applicable

select primary key

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

Re: select primary key

Hi,

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

Thanks,