Comparing sums

[#1]

So I'm comparing the sum of field1 with the sum of field2. I want to display the "agencyID" when the sum of field 1 and field 2 are not equal to each other.

However, there are many agency ID's associated with each of those sums but I want to display the agency ID that made the sum of field 1 and field 2 not equal to each other.

I want to put this in a straight table

[#2]

Hi,

Which version of qlikview you are using?

if on QV11 then can do this by specifying the dimension limiting expression.

thanks & Best Regards,

Kuldeep Tak

[Oleg_Troyansky]

I wonder if this Set Analysis formula would work:

count({<AgencyID={"=sum(Field1)<>sum(Field2)"}>} AgencyID )