topic Re: Select in Field in QlikView

Select in Field

Mon, 17 Nov 2014 17:38:25 GMT

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

Re: Select in Field

marcus_malinow — Mon, 17 Nov 2014 17:42:45 GMT

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

Re: Select in Field

Mon, 17 Nov 2014 17:51:50 GMT

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.

Re: Re: Select in Field

JonnyPoole — Mon, 17 Nov 2014 18:20:06 GMT

Here is a technique that worked (after multiple tries )

Build the search string as a variable as follows

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.

Re: Select in Field

Mon, 17 Nov 2014 18:37:09 GMT

Thanks Jonathan, it works great.