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

aj_954 — Wed, 05 Jan 2022 14:34:15 GMT

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.

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

chris_djih — Wed, 19 Jan 2022 13:40:22 GMT

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

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