Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.