Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create a does not equal search string?

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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Have you tried as search string

<1349>1349

or

='<1349>1349'

?

View solution in original post

6 Replies
sunny_talwar

May be do it in two actions

1) Select in Field

Field -> ResultTech

Search String -> 1349

2) Select Excluded

Field -> ResultTech

sunny_talwar

Another option is to do like this

Select in Field

Field -> ResultTech

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

swuehl
MVP
MVP

Have you tried as search string

<1349>1349

or

='<1349>1349'

?

View solution in original post

Not applicable
Author

Thank you very much, appreciate the help.

MarcoWedel

maybe also possible:

='=ResultTech<>1349'

regards

Marco

MarcoWedel

another one:

(*^1349)

thanks to Stefan for his very nice post

Compound Search - demystified

Marco