Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
JohanLind1979
Contributor III
Contributor III

Action field value separator already in values

Dear community, I´ve got a field where the values contain ';'. I need an action to select two values in that field based on texts in variables when the user enters the sheet. The problem is that ';' is the separator for values in the sheet actions. My field values look like this:

'MTP 2020; 2021-2023'

'MTP 2021; 2022-2024'

'MTP 2022; 2023-2025'

(Which means Mid Term Plan, approval year 2022, containing plan values for the years 2023-2025)

I use two variables that could contain values like 'MTP 2020; 2021-2023' and 'MTP 2021; 2022-2024'. The sheet action should make the selection in the field based on what´s in the variables.

How can I get the variable texts selected in the sheet action?

Labels (1)
1 Reply
JohanLind1979
Contributor III
Contributor III
Author

Solved the issue using a bookmark instead, and added an action to apply the bookmark. 

Solution:  Typed this into search for field=Field

Field={"=Field=vVariable1"}&Field={"=Field=vVariable2"}

Still, if you have a solution using action to select values in field or select search value, please add to this post.