Nested aggregation not allowed using sum and if statement ( tried usingaggr)

[aj_954]

Hi,

I am trying to sum the counts of a variable:

here is the code:

=sum(if(aggr([Requesting Agency] = 'JAY',count([Servicing Agency])),1))

but I am getting an error. I want to count the total number of times of the servicing agency being a value when the requesting agency = jay. 

[rwunderlich · Accepted solution]

count({<[Requesting Agency]={'JAY'}>}[Servicing Agency])

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com