Trying to compare two charts/maps of current selections vs. excluded selections

[xthojanalyst]

I want to have two maps side by side to compare.  Map 1 would update with current selections, while map 2 would do the complete opposite and display data where selections are excluded (and this would keep going for multiple selections in the app).

So e.g.

If I wanted to compare income of counties with avg median income>60,000. Map 1 would show data for counties  with income > 60,000 and map 2 would auto update to show data for counties with median <60,000.  I can write a set analysis but I'd have to do that for every type of data I wanted to compare.  Is there something a way to do this where map 2 would show excluded selections automatically?

[rubenmarin]

Hi, you can try with set analysis, using {1-$} to filter the excluded values of current selection.

If map1 expression is: Sum(Sales)

map2 expression can be: Sum({1-$} Sales)

[xthojanalyst]

How about when I select other fields though? This would only work on 'sales' correct? I want the maps to update automatically based on all possible selections.

[rubenmarin]

Hi, that was an example, using a field Sales that I invented just to make the example, the important thing is that you can use the set analysis "{1-$}" to use the excluded values.

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

[xthojanalyst]

Thanks, I understand set analysis and how to use it but was wondering a different method where I didn't have to write a set analysis for every field and can just update automatically based on user selections.

[Or]

You don't have to write this for every field - just a {1-$} in every expression where you want to only show the excluded values. This isn't specific to a field.