And Operator in Selection

[Anonymous]

I am QV Version 10 working on a data set of employees who have completed different training courses. Here is what I require. When I make a selection of courses I want to retrieve those employees who have taken all of the courses in my selection along with a total count for the list of employees. The default action is to bring back a list of employees who have taken any of the courses from the selection. My rough logic is this: A list of employees where the distinct count of courses taken is equal to the count of possible courses from the selection.

[swuehl · Accepted solution]

Well, sounds like a reasonable idea, try maybe like this:

Create a list box with a field expression (from the field list drop down, at the very bottom).

Then as expression something like:

=aggr(only({<Employee ={"=count(distinct Courses)=count(total distinct Courses)"}>} Employee), Employee)

Another idea is to use an AND-mode list box for selection, please check the Help for more details (and the restrictions applied).

Hope this helps,

Stefan

[Anonymous]

That works great... thanks for your help...