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.

gerhardl
Contributor 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

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Select Values that exist more than once

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).

2 Replies
MVP
MVP

Re: Select Values that exist more than once

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
Contributor II

Re: Select Values that exist more than once

Nice. Thanks