topic Re: Comparing sums in QlikView

Comparing sums

Wed, 01 Aug 2012 18:50:37 GMT

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

Re: Comparing sums

Thu, 02 Aug 2012 03:43:15 GMT

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

Re: Comparing sums

Oleg_Troyansky — Thu, 02 Aug 2012 03:46:02 GMT

I wonder if this Set Analysis formula would work:

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