topic Re: How to create a does not equal search string? in QlikView

How to create a does not equal search string?

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

There is probably something small I am missing, but I can't seem to figure it out with my limited knowledge of the product. I am trying to create a simple button that will pull values that do not equal 1349. It makes me think that <> isn't correct to use for does not equal, but I am not sure what should be used instead.

Re: How to create a does not equal search string?

sunny_talwar — Wed, 09 Aug 2017 15:47:32 GMT

May be do it in two actions

1) Select in Field

Field -> ResultTech

Search String -> 1349

2) Select Excluded

Field -> ResultTech

Re: How to create a does not equal search string?

sunny_talwar — Wed, 09 Aug 2017 15:49:13 GMT

Another option is to do like this

Select in Field

Field -> ResultTech

SearchString -> ='(' & Concat(DISTINCT {<ResultTech -= {1349}>} Chr(34) & ResultTech & Chr(34), '|') & ')'

Re: How to create a does not equal search string?

swuehl — Wed, 09 Aug 2017 16:01:06 GMT

Have you tried as search string

<1349>1349

='<1349>1349'

Re: How to create a does not equal search string?

Wed, 09 Aug 2017 17:28:41 GMT

Thank you very much, appreciate the help.

Re: How to create a does not equal search string?

MarcoWedel — Wed, 09 Aug 2017 19:50:07 GMT

maybe also possible:

='=ResultTech<>1349'

regards

Marco

Re: How to create a does not equal search string?

MarcoWedel — Wed, 09 Aug 2017 20:42:39 GMT

another one:

(*^1349)

thanks to Stefan for his very nice post

Compound Search - demystified

Marco