Issue with Search in Field

[john_duffy]

Hello All.

We have added functionality to allow our users to copy a list of values for an external source (eg. xls), paste the list into an input box and then search on the values.  This saves the users having to key in the individual values.  This works fine unless there is a QlikView key word in the search list (eg. NOT).

I have attached a very simple example of this scenario.  In the example, the list received from the user contains 3 values - ABC, NOT and REF.  Using the Select in Field action, we want the 3 values to be selected.  Instead, all values except REF are being selected.  QlikView is selecting ABC and every value that is not REF.

Any suggestion on how to handle this scenario?  Keep in mind this is a very simple example.  In reality, the list can contain hundreds of values and could potentially contain multiple values equivalent to QlikView key words.

Thanks.

[isingh30]

Hello Marcus,

What is this - ='=. If you can explain a bit.

Thanks.

[marcus_sommer]

It's necessary to evaluate the content as expression. With just =match(Field1, ''ABC'', ''NOT'', ''REF'') it would be regarded as a string.

- Marcus

[hic]

...or to be a little more specific: If you write

then the expression will be evaluated when the action is executed, and the result will be used as search string. This is not what you want.

But if you instead quote the expression

(and use two single quotes as an escape sequence for single quote) then the expression inside the quotes will be used as search string. I.e. the expression will be evaluated in the search context instead of in the action context. Which is what you want.

HIC

[isingh30]

Thank you Henric