Display all areas on a map when a filter is applied

[AMonot]

Hi everyone ! 

I have a map of France that displays some informations per regions. With zero filters it works properly, but whenever I put a specific filter it deletes some regions. Not all the empty ones, just a few of them, and I cannot understand where this issue is from... 

Here are some pictures: 

This one without any filters. I'm sorry I have to hide all the datas, I can only tell you all of those are positive numbers

I applied a filter on my whole document here, and the map does not display some regions (like "Bretagne", "Grand Est", "Bourgogne-Franche-Comté" or "Corse"), even though the ones without any number are grey (but still appear). 

I would like them all to show up on the map, whatever the filter I put on, and have only the numbers & colors to change whenever I apply a filter. And if there is nothing in the specific regions, they should be in grey, like the other ones. 

Thanks in advance for your help, let me know if you need any additional informations ! 

Kind regards,

AM

[rbartley]

Hi AM,

It would be easier to answer this if you could post the definition of the filter.

[AMonot]

Hi Rbartley ! 

Thank you for replying. I still have not found any solution... 

The filter is a basic customer-type one. For the examples above, I clicked on "Industry" or some equivalent. Depending on the filter, some regions will appear and some others will not... but the problem basically is the same wether I am applying this filter or another. 

For this "Industry" filter, you can notice we do not have any activity in the regions that do not appear, AND the grey ones that appear properly. Still don't know why Qlik wants to differenciate them... 

Please let me know if you need any other information ! 

[rbartley]

If you replicate the map as a table, what happens when you apply the same filter?  Do the grey regions appear as 0, but the other regions disappear (because there is no matching data)?

Could you create some dummy data to replace anything sensitive and post the app here?

[rbartley]

Take a look at the attached app.  I loaded some dummy data as follows:

I then created a map with an area layer based on the Region field:

In the colors property I used =if(Sum(Value)>0,Blue(),LightGray()) and I added the measure Sum(value) to the tooltip.  I then added a filter on Industry.

When I selected Industry A, only the Industry A regions were shown in the map and table

I then modified the colors and tooltip expressions in the map using set analysis, as follows:

=if(Sum({<Industry=>}Value)>0,Blue(),LightGray())

Sum({<Industry=>}Value)

Now, I see all the regions, no matter which Industry I select (while the table remains filtered):

Is this what you are trying to achieve?

[rbartley]

p.s. to ignore all selections, just change the expression to include Sum({1} Value)  rather than specifying one or more field names in the set analysis.