Discussion Board for collaboration related to QlikView App Development.
I am currently using a 'Search bar' object to search for values.
I used the following to search for courses containing both words: (*finance* & *investment*).
If I wanted to exclude the word 'property' from the results, what syntax would I use?
Thanks in advance for any help!
To exclude the specific word from searches, follow the sequence.
1. Make your search query in the list box search. And get the required result with Finance and investment.
2. Select all the results shown on the list box, excluding unwanted values. It will get highlighted by the color green.
3. Again in the search query box, type "-" & "Word to exclude", in your case, it will be like "-Property".
In the end, the final result will display everything including Finances and Investment but excluding Property.
I have attached the images which I tried.
View solution in original post