Filtering on multiple selections in field

[#1]

I'm experiencing the following problem. I have two values Current Division and Previous Division. The user is able to select multiple divisions from a field in a multibox to filter values in a straight table

I need to be able to check whether the previous division doesn't match current division (selected from the multi-box field) and count the number of this occurs by a field called MATTER_ID.

Basically the following conditions need to be met:

• Multi-box selected Business Division (BUSINESS_DIVISION) = Current Business Division(BUSINESS_DIVISION_D)
• Multi-box selected Business Division (BUSINESS_DIVISION) <> Previous Business Division(P_BUSINESS_DIVISION_D)

This is a simplified version of the expression that I'm using:

=count(

{

$<BUSINESS_DIVISION_D=p(BUSINESS_DIVISION),P_BUSINESS_DIVISION_D=e(BUSINESS_DIVISION)>

}

distinct MATTER_ID))

This works fine when only one value is selected. When mutiple values are selected it works MOST times EXCEPT when the business division changes from one selected division to another selected division. We don't want those occurances to be counted as a change in business division because it occurs within the selected values.

It appears that QlikView just counts the number of times this occurs for each business division and sums the totals.

Any idea how to do this?