topic Re: Select exclude for the given values in QlikView

Select exclude for the given values

Tue, 07 Jun 2011 13:34:58 GMT

I ve a field 'ID ' which has values as (a,b,c,d,......). Here I want to select all the values other than a & b using an action in a button.

Using the 'Select in Field' action on ID field, I tried <>(a|b) expression , which is not working.I could do it using two actions 'Select in Field, Select Excluded' on the ID field.

Is it possible to do it using single action.

Thanks,

Sankar

Select exclude for the given values

erichshiino — Tue, 07 Jun 2011 13:45:12 GMT

You can use this expression there (including the = sign)

='('& concat({<ID-={a,b}>} distinct ID, '|')& ')'

This will construct a string will all the values, excluding A,B. : (c|d|e|f)

A bit complicated expression to a task that could be done with two actions...

Hope this helps,

Erich

Select exclude for the given values

Tue, 07 Jun 2011 15:57:59 GMT

How about:

Select in Field: Field (A|B)

Select Excluded: Field

Select exclude for the given values

Wed, 08 Jun 2011 08:20:33 GMT

Hi Erich,

Thanks for the solution.

One more requirement to select 'aa aa' |'bb bb' in the ID field using the action in the trigger.Due to the space b/w the words , usual expression - (aa aa|bb bb) is not working.

Re: Select exclude for the given values

dhruv_sampat — Fri, 30 Jun 2023 07:57:06 GMT

Hi Erichshiino,

When i used your expression, added it to a button and using "Select in field" and then added an Exclude so i can confirm that only those 2 are being excluded, it seems to be picking the first valid value alphabetically and then excluding it as well as the two in the expression.

e.g.

='('& concat({<BPR_0-={'GBI-103658','GBI-102288'}>} distinct BPR_0, '|')& ')'

and it excluses " ", "Axxx", 'GBI-103658','GBI-102288' which i cant figure out why.

Please assist.

Re: Select exclude for the given values

BrunPierre — Fri, 30 Jun 2023 14:49:10 GMT

='('& concat({<BPR_0-={"GBI-103658","GBI-102288"}>} distinct BPR_0, '|')& ')'