how to display in bar graph who are not in the selection (filter Selection)

[Qlikuser09]

select a filter and display the values that do not match the filter selection , 

For example I have a dimension : User Name , and

measure : Count(Distinct If([active_Report]=1,[Name_Report])),

and i am selecting a deptname filter , not it applies the selected filter values(depts users that are using the reports   to the chart. but i want to show the reports that are not used by the selected dept.

[JordyWegman]

Hi,

Do you have some test data?

For your example you can better use set analysis than IF() statements in a field.

Since I don't have some data to test, I've created a test app with a possible example. Here you have 2 KPI's and corresponding tables. If you make a selection in 1 field, Dim1, we show for one section what is related. And for the other section what's not related. The -= is ensuring you get whatever is not selected.

You should be able to use this concept. The app is attached.

Jordy

Climber

[Qlikuser09]

Thanks for the reply , but some how its not working in my case( 1-$  ) is working fine but it gets applied to all the filters i want it to be applied to only dept dimension is there a way i can achieve this

Count({1-$}Distinct If([active_report]=1,[NameReport]))