Multi-select Filter Action (How can I select multiple countries on a map & use them as a filter?)

Question & Answer
1

Hey everyone,

I’m quite new to qjuicksight and have the following problem:

I have a filled map visual and want to enable my dashboard-consumer to click on several(!) countries so that the rest of the dashboard will be filtered according to this selection.

So basically, I want the “Filter same-sheet visuals” action, but with a multi-select option.

Is there any way to solve this issue?

Thanks in advance!

2

Hi @anonymousDashboard

Unfortunately, quick sight doesn’t have a built-in option for selecting multiple countries on a filled map and filtering the rest of the dashboard based on that selection, but don’t worry, there’s a workaround!

first, create a dropdown list called “SelectedCountries” with all the available countries. Then, create a calculated field called “CountryFilter” that checks if each country is in the selected list

{Country} IN split({SelectedCountries}, ‘,’)

Apply the “CountryFilter” as a filter to the visuals you want to be filtered based on the selected countries. This way, only the data for the selected countries will be shown

To let users select multiple countries, add an action to the filled map. This action will update the “SelectedCountries” dropdown with the chosen countries whenever the user interacts with the map

That’s it! Now, when the user selects multiple countries on the filled map, the visuals will be filtered based on the selection

remember, this workaround involves using a parameter and a calculated field It may require a bit of setup, but it gets the job done in quick sight

hope help’s

1 Like
3

I’m afraid I don’t understand what you mean with …
“To let users select multiple countries, add an action to the filled map. This action will update the “SelectedCountries” dropdown with the chosen countries whenever the user interacts with the map”

How do I update the dropdown using an action?

1 Like
4

Hi @anonymousDashboard ,

We have a Product Feature Request in queue for multi-select capability for actions. Please have your AWS contact file a customer Influence against this PFR ( Internal link ). In case you don’t have an AWS contact, send me your org name and I will file a customer influence on your behalf.

In the interim, you can use a filter control to do the selection. Since multi-select parameters can be used only in limited functions, we can’t really do any workarounds from visual clicks currently.

Regards,
Arun Santhosh

5