Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
I wonder if this Set Analysis formula would work:
count({<AgencyID={"=sum(Field1)<>sum(Field2)"}>} AgencyID )