Selecting fields from expression filter

[mikael-c]

Completely new to Qlik Sense.

I have 2 fields: nom_station (text) and station_id (numeric).

I created a filter with this expression in the field name: =nom_station&' (#'&station_id&')'

When you make a selection on this field, neither nom_station or station_id are selected in green, they are white. I would like to select them green because i wish to reuse station_id in other formulas such as GetFieldSelections() and GetSelectedCount().

Here are the data parameters for the filter.

And when I select "Caserne 05 (#31)", I wish that station_id 31 gets selected.

Which is not the case, as seen in this other filter panel with just station_id in it (without the expression). It is white, but I need it to be green.

Thanks for your help!

[dwforest · Accepted solution]

You might be able to use Dual() to display nom_station&' (#'&station_id&')' and have station_id as the value; this wouldn't select values in the station_id field but could possibly replace it depending on the workflow.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunc...

[mikael-c]

This actually does select the field!
Thanks for your help!!