Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
Specialist III
Specialist III

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

Highlighted
Not applicable

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.

Highlighted
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

Highlighted
Not applicable

Thanks Jonathan, it works great.