Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

syntax- searching string for an action

Hi everyone,

I would like to add an action, which helps to choose the searchwords i want. My problem is, if there are similar words, the action chooses all of them, but I want just one. for example:

there are:

abc

abcd

abcds

blabli

my expression for the searching string is:

= '("abc"|"blabli")'

this expression chooses all abc* strings, but i just want  abc only, can somebody help me please?

Labels (1)
7 Replies
tresB
Champion III
Champion III

I don't get the result so.

Untitled.png

Could you post your sample app that replicates the issue?

settu_periasamy
Master III
Master III

Hi,

I think you are trying the same expression in the Listbox -> Search..

("abc"|"blabli")

Capture.JPG

But, if you assign the expression in the Action Button, it will give your desired result, not  'abc*'..

engishfaque
Specialist III
Specialist III

Dear Sevdolicious,

Here it is,

='(' & Concat ({<YourFieldName = {"abc*"}>} Distinct YourFieldName, '|')')'

Kind regards,

Ishfaque Ahmed

tresB
Champion III
Champion III

Even in the listbox, using 'Normal Search' mode - 'exact match' should have worked. Unfortunately, that doesn't work anymore.

settu_periasamy
Master III
Master III

Yes, I tested it. It gives all the value.
But if we give (abc|blabli)  -> This give exact value

Not applicable
Author

My searching string includes 2 words, therefore i had to use These " ".

Thank you all for your help

settu_periasamy
Master III
Master III

Hi,

Look this as well   Compound Search - demystified