Map object - display all area ignoring the selection

fabrice_lattern — Wed, 30 Jun 2021 15:11:35 GMT

Hello,

I am currently using the "Map" object in QlikSense to represent some sales on a world map. I first extracted the data from GeoAnalytics connector to get the country / administrative L1 & L2 codes & names, and created a dummy sales table as follow :

Then I created a Map with dimension "L2 Name", and some configuration to give the Country Code / L1 & L2 code in the location configuration :

The data map is colored using a simple SUM(Amount), and everything is fine as far as I do not perform any selection on a field from "Data" table. Example here by selecting "Colorado" in "L1 Name" field :

But when I select a Year, the map only displays the area for with I have some data

I would like to keep all other areas. I tried by modifying the dimensions used in the map with some aggr(only({1} Dim), Dim) but it does not work. I would also like to avoid to create some dummy entries (because it is dirty and in real life it would mean a lot of records which is not sustainable).

Thanks in advance if you have any idea of the way to handle this ! You will find enclose the test QVF I have created (we are still in June 2020 version in case their was some enhancements in between).

Best regards,

Fabrice

topic Map object - display all area ignoring the selection in App Development

Map object - display all area ignoring the selection