topic Re: Search string in QlikView

Search string

Anonymous — Wed, 03 Dec 2014 06:54:36 GMT

i have a requirement where i need to select all the data in list box except one string i.e Branch Segment . i need to select all the values except branch Segment .

thanks

Re: Search string

tresB — Wed, 03 Dec 2014 06:58:50 GMT

Search string, something like:

='('&Concat({<YourField=- {'Branch Segment'}>} Distinct YourField, '|') &')'

or,

First trigger: To select brach segment

Second trigger: To select excluded

Re: Search string

its_anandrjs — Wed, 03 Dec 2014 06:59:29 GMT

Hi,

In the list box write expression

Assume BranchDetails contains branch Segment and other details also

=If( Not Match(BranchDetails,'branch Segment')

If( BranchDetails <> 'branch Segment' ,BranchDetails)

Regards

Anand

Re: Search string

jagadeesh_diamo — Wed, 03 Dec 2014 07:00:35 GMT

First you select 'Branch Segment' then click on SELECT EXCLUDED.

Re: Search string

jagadeesh_diamo — Wed, 03 Dec 2014 07:17:31 GMT

Good...