Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here
cancel
Showing results for 
Search instead for 
Did you mean: 
dmohanty
Partner - Specialist
Partner - Specialist

Select in Field Action - wildcard value in Search String

Hi All,

I want to pass a value in Search String of the Select in Field Action, which is dynamic and changes frequently.

Let's say, the field name is Product and it has value is in format 'Medicine_*'. Today it can be 'Medicine_Tablet', the next day it can be 'Medicine_Capsule', some other day it can be 'Medicine_Cream'.

Each day has a unique 'Medicine_*' value.

What Function/How would be the value/function in Search String value?

Select in Field - PRODUCT

Search String - 'Medicine_*'

Labels (1)
11 Replies
James10
Contributor
Contributor

Hi,
Wildcard values in a Select in Field action can sometimes behave differently depending on how the search string is interpreted. It’s worth checking the exact search mode, field values, https://medannotate.com  and wildcard syntax being used. A small reproducible example with the expected and actual selection behavior would also make troubleshooting much easier for the community.

larry99
Contributor
Contributor

Hello,

Wildcard searches can be tricky when the value comes from a variable or action, especially if the search string is interpreted differently than expected. It helps to keep the expression simple and test the generated value separately. For readers in San Diego, choosing a reliable, lab-tested local provider can also make product selection easier, such as a dispensary in Mission Bay.