topic And Operator in Selection in QlikView

And Operator in Selection

Anonymous — Mon, 13 Aug 2012 22:23:23 GMT

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.

Re: And Operator in Selection

swuehl — Mon, 13 Aug 2012 22:30:59 GMT

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

Re: And Operator in Selection

Anonymous — Tue, 14 Aug 2012 19:34:30 GMT

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