Selecting duplicates with a button

Wed, 19 Jun 2013 17:22:51 GMT

I have a list of accounts that appear on an unavailable report every month. These accounts are differentiated by a unique Account_Id.

If an account is listed on a report in consecutive months then there will be multiple instances in the database with only the Report_Date being different between each row.

for example:

Account_Id Report_Date Reason

111 6/1/2013 No Access

111 5/1/2013 No Access

112 5/1/2013 No Access

I need to be able to select the number of accounts with variable numbers of duplicates. So a button for anything with 2 duplicates, a button for 3 duplicates, etc. I have already created a table that shows the number of duplicate occurences per account. Just want a single button to make a selection.

The only field that will change is the Report_Date so I was attempting to do a Select in Field using Account_ID and the following count function in Search string but with no luck.

='=count(Report_Date)>5

I am pretty sure this is not a difficult issue and am just missing something.

I am also open to any ideas on how to modify the load to count duplicate instances of an Account_Id so that it can be used as a variable for selection purposes.

Thanks

Re: Selecting duplicates with a button

Wed, 19 Jun 2013 17:39:19 GMT

Hi,

Look at the attachment. Maybe can help.

Rebeca

topic Selecting duplicates with a button in QlikView

Selecting duplicates with a button

Re: Selecting duplicates with a button