how to exclude a value from being plotted in QLIK bar graph

[aj_954]

Hi,

I have a data set that has the following:

Requesting Agency and Servicing Agency

I am trying to plot the count of  times of servicing agency, when the requesting agency = 'JAY'. 

Here is my code:

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

It works fine, however, if the Servicing Agency is = "jay" it also plots it. How do I exclude that value from being plotted. 

[chris_djih]

For this simple if statement, try to use set analysis:

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