topic Re: syntax- searching string for an action in QlikView

syntax- searching string for an action

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: syntax- searching string for an action

tresB — Mon, 11 Apr 2016 04:24:53 GMT

I don't get the result so.

Could you post your sample app that replicates the issue?

Re: syntax- searching string for an action

settu_periasamy — Mon, 11 Apr 2016 05:00:24 GMT

Hi,

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

("abc"|"blabli")

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

Re: syntax- searching string for an action

engishfaque — Mon, 11 Apr 2016 05:35:35 GMT

Dear Sevdolicious,

Here it is,

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

Kind regards,

Ishfaque Ahmed

Re: syntax- searching string for an action

tresB — Mon, 11 Apr 2016 05:36:53 GMT

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

Re: syntax- searching string for an action

settu_periasamy — Mon, 11 Apr 2016 05:55:06 GMT

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

Re: syntax- searching string for an action

Mon, 11 Apr 2016 08:17:17 GMT

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

Thank you all for your help

Re: syntax- searching string for an action

settu_periasamy — Mon, 11 Apr 2016 09:42:37 GMT

Hi,

Look this as well Compound Search - demystified