Button: select multiple (opposite) values in different fields at the same time

[arn_prr]

Hello to all,

I am looking for a specific case of button configuration:

I already know how to select values from multiple fields with a button but the tricky part is that I want to add the selections of those fields. Here is an example:

I have a visualisation with several dimensions/fields including:

• - Region of the world (for example a continent),
• - Country.

I want my button to select the region "Africa" but at the same time select the country "Japan" which would technically be excluded from the selection due to region being "Africa".

Is there a way of doing so ? So far I have to say that I am not sure if this is possible via a button.

Thanks.

[marcus_sommer]

A direct field-selection is not possible but both conditions could be combined within a set analysis, like:

sum({< Region = {'Afrika'} > + < Country = {'Japan'}>} Value)

[arn_prr]

Thanks for the reply, sadly I want to use this feature as a filter for the whole page but only by having a favorite or a button so I am not sure that this solution by using an aggr would be possible.

[Or]

You could use a second state and then combine the conditions in your expressions, perhaps?

[arn_prr]

Sorry, my Qlik Sense is in French so are you talking about Inherited State ?

If so, I would be curious to have an example to understand how this would work.

Even if this is not the way you are talking about, I would be curious to see an example of the solution you are suggesting.

Once again, thanks a lot.

[marcus_sommer]

If appropriate set analysis conditions are not practically enough I think I would add the essential information within the data-model, in the simplest way an extra field in the country-dimension-table, like:

if(Region = 'Afrika' or Country = 'Japan', true(), false()) as SheetFilter

and then selecting against this flag.

Another way to control excluding and/or overlapping hierarchically values may be to implement a The As-Of Table - Qlik Community - 1466130.

[Or]

https://help.qlik.com/en-US/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Visualizations/alter...

[arn_prr · Accepted solution]

In the end, the best way to do it the way I wanted was to put a 'Tag' system.

Countries in Africa and Parkistan all have the same tag, that I use to filter.

Thanks to all of you for guiding me.