I have a large number of records in my Qlikview table. One of the fields is Employee_ID. Under normal cricumstances there would be an unique employee id for each record. In some cases a single employee ID will appear in more than one record. I would like to display those particular records in list box.
Using the statement =Count(distinct(EMPLOYEE_ID))>1 in the Calculation Condition of the List Box does not work. I do not think I am using that option corectly.
The table box still shows records that have a Employee_ID that only appears in taht records. The filtering that is required is like Select * from table where Count(Employee_ID) > 1 Group By Employee_ID. Can Qlikview do this sort of filtering in the front end.
Ah, I paid attention to the post itself rather than the title, so I gave you instructions for a list box like the post requested. For a table box, use the expression I gave you as a calculated dimension, then suppress when value is null.
Instead of doing a Count(DISTINCT... could you just create a table where the dimension is Employee ID and the Expression is:
Count( [Employee ID])
and then sort this descending. This should give you a list of the number of times each Employee ID appears in the table. If, as you say, there should be a unique Employee ID for each record then most of the rows will have a count of 1 and only those that appear in multiple rows will have a count > 1.
To create a list box out of it you would go to, as John said, the general tab on the List Box properties and select <Expression>...then add the following expression:
