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: 
gerhardl
Creator II
Creator II

Select Values that exist more than once

Hi There,

How can I select all values in a certain field, that appear more than once in a particular table?

I have a key field (appears in 4 different tables) called [Account No]. One table shows all accounts with Funeral Policies. Some accounts have more than one policy.

I want to create a button/bookmark (or yes/no list box) that then selects all accounts that have more than one policy.

Thanks,

Gerhard

1 Solution

Accepted Solutions
swuehl
MVP
MVP

It should be possible to create a button with a select in field action.

Use

[Account No]

as field, and as search string

='=count(POLICYFIELD)>1'

(as stated, including the single quotes and two equal signs).

View solution in original post

2 Replies
swuehl
MVP
MVP

It should be possible to create a button with a select in field action.

Use

[Account No]

as field, and as search string

='=count(POLICYFIELD)>1'

(as stated, including the single quotes and two equal signs).

gerhardl
Creator II
Creator II
Author

Nice. Thanks