Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to exclude only SEGMENT_SUB=Related Coy ?

Hi All

I like to add the filter using button.

My condition is Exclude SEGMENT_SUB=Related Coy

Which is same as i tick on individual check box except not tick on Related Coy.

May i know how to write the button script For example if i want to select only SEGMENT_SUB = Related Coy

Action Go to select in field :-

Field  = SEGMENT_SUB

Search string = Related Coy

But now my requirement is select all other label exclude Related Coy.

i assume it should be some thing like :-

Search string not= Related Coy

Hope some one can advise me.

My Objective is to analyse the chart on GP% if exclude related coy .

In my next post i will post my QV Doc

Paul

1 Solution

Accepted Solutions

Re: How to exclude only SEGMENT_SUB=Related Coy ?

Hi,

You can ssign two actions to your button. In the First Action, Select "Related Coy" and make the second

action just "Select Excluded". Something like

1. Select in Field

   Field = SEGMENT SUB

  Search String = Related Coy

2. Select Excluded

  Field = SEGMENT SUB

3 Replies

Re: How to exclude only SEGMENT_SUB=Related Coy ?

Hi,

You can ssign two actions to your button. In the First Action, Select "Related Coy" and make the second

action just "Select Excluded". Something like

1. Select in Field

   Field = SEGMENT SUB

  Search String = Related Coy

2. Select Excluded

  Field = SEGMENT SUB

Re: How to exclude only SEGMENT_SUB=Related Coy ?

This will very helpful

Compound Search - demystified

paulyeo11
Valued Contributor II

Re: How to exclude only SEGMENT_SUB=Related Coy ?

Yes it work fine now , many thank

Sent from my iPhone

Community Browser