topic Re: Select Values that exist more than once in QlikView

Select Values that exist more than once

gerhardl — Thu, 17 Jan 2013 14:21:40 GMT

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

Re: Select Values that exist more than once

swuehl — Thu, 17 Jan 2013 14:26:10 GMT

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

Re: Select Values that exist more than once

gerhardl — Thu, 17 Jan 2013 14:36:37 GMT

Nice. Thanks