topic Re: Button: select multiple (opposite) values in different fields at the same time in App Development

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

arn_prr — Wed, 21 May 2025 09:48:00 GMT

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.

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

marcus_sommer — Wed, 21 May 2025 16:02:04 GMT

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

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

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

arn_prr — Thu, 22 May 2025 08:16:45 GMT

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.

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

Or — Thu, 22 May 2025 08:30:26 GMT

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

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

arn_prr — Thu, 22 May 2025 09:31:28 GMT

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.

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

marcus_sommer — Thu, 22 May 2025 10:02:37 GMT

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.

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

Or — Thu, 22 May 2025 10:09:32 GMT

https://help.qlik.com/en-US/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Visualizations/alternate-states-comparative-analysis.htm

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

arn_prr — Mon, 02 Jun 2025 08:00:55 GMT

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.