Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select in Field

I am having an issue with writing a 'Search String' for a 'Select in Field' action that selects everything NOT equal to a value.  For example if a Field, X, contains the set {A, B, C, D, E}, what would the 'Search String' be if I want to select all values OTHER than 'C'?  I have tried many different combinations.  If the data were numeric it would be simple (<>), but it seems to be more complicated with a string.

Thanks

1 Solution

Accepted Solutions
JonnyPoole
Employee
Employee

Here is a technique that worked (after multiple tries )

Build the search string as a variable as follows

Capture.PNG.png

below you can see what the variable equals to in the input box on the right

Then invoke 'select in field' action passing the variable as the Search String . It should work.

Capture.PNG.png

View solution in original post

4 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Have you tried using Select in Field with 'C', then Select Excluded on the same field?

Not applicable
Author

Yes, I have tried and that method doesn't seem to work 100% of the time.  There has to be a way to do this in one step.

JonnyPoole
Employee
Employee

Here is a technique that worked (after multiple tries )

Build the search string as a variable as follows

Capture.PNG.png

below you can see what the variable equals to in the input box on the right

Then invoke 'select in field' action passing the variable as the Search String . It should work.

Capture.PNG.png

Not applicable
Author

Thanks Jonathan, it works great.