Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I have primary key how can you test that one?

I have primary key how can you test that one?

4 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

Can you be more clear?

It will hold distinct values, No reparation is allowed in this.

Regards

ASHFAQ

Not applicable
Author

Question is not clear. Can u make it clear

I cant understand what you need to know

jagan
Luminary Alumni
Luminary Alumni

Hi Raja,

Try this expression in Text object if you get a positive number then it is not a primary key.

=Sum(Aggr(If(Count(PrimaryKeyDimension) > 1, 1, 0), PrimaryKeyDimension)

Hope this helps you.

Regards,

Jagan.

Anonymous
Not applicable
Author


you can also put the dimension in the list box and check "show frequency" filter. If it is more than 1, this dimension is not primary key.