Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
tamilarasu
Champion
Champion

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

View solution in original post

3 Replies
tamilarasu
Champion
Champion

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

settu_periasamy
Master III
Master III

This will very helpful

Compound Search - demystified

paulyeo11
Master
Master
Author

Yes it work fine now , many thank

Sent from my iPhone