Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Employee
Employee

Re: Re: Select in Field

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

4 Replies
marcus_malinow
Valued Contributor III

Re: Select in Field

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

Not applicable

Re: Select in Field

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.

Employee
Employee

Re: Re: Select in Field

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

Re: Select in Field

Thanks Jonathan, it works great.

Community Browser