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.
datanibbler
Esteemed Contributor

Key issue

Hi,

in a report I'm currently working on, there are three tables from our database.

All three are linked via the item_number, so that has that % prefix.

One of them is the item_master.

When I hover over the keyfield %Item_number in the table_viewer, it says "Key", which means that the field is not unique.

<=> In a straight_table diagram, I can see that with the dimension "item_number" (not the one with the % prefix), there is only

        one line per item_nr - and it's the same when I use the keyfield (with the prefix) as dimension

Can anyone help me here? The keyfield seems to be unique (which it should be in a table labeled *_master) - but in the table_vieweer, QlikView tells me it is not ...

Thanks a lot!

Best regards,

DataNibbler

Tags (1)
4 Replies

Re: Key issue

Key fields are Unique in all databases!

Employee
Employee

Re: Key issue

Without the data, it is impossible to say what has gone wrong - if anything.

"Perfect Key" means that the keys are unique and the list is complete.

"Primary Key" means that the keys are unique but the list is incomplete.

"Key" means that the keys are non-unique - there are duplicates.

I would make a chart where you as dimension use the key and as expression use Count(Somefield) to see if your table has duplicates of the key.

HIC

Luminary
Luminary

Re: Re: Key issue

Henric Cronström wrote:

"Perfect Key" means that the keys are unique and the list is complete.

What does "list is complete" mean? Does it mean that the values are present in both the tables and match 100%?

Thanks in advance.

Cheers,

DV

Employee
Employee

Re: Key issue

It means that this table contains all values of the field - also all the values of the field in other tables. For example, if you have two tables, each with three records, where one contains the values 'A', 'B' and 'C' and the other contains 'A', 'B' and 'D', then the key is a Primary Key in both tables, but a Perfect Key in neither.

If one of the tables instead has four records and a key with all four values, then it would be a Perfect Key in that table.

HIC

Community Browser