Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

NOT condition in Button?

hi all, i made a button that filtering fields from the multi box.

in the button i made two "select in field" that in each of one them i made a condition for each dimension from the multi box.

exp:

dimension 1 - field= GROUP : search string= china

dimension 2  - field= AREA : search string=("beijing"|"shanghai")

does anyone know how i do NOT condition that will give me

dimension= field= GROUP search string=  NOT china.

thank you 

1 Solution

Accepted Solutions
ekech_infomotio
Partner - Creator II
Partner - Creator II

Hi Eran,

you could make a 2 (3)-step selection:

first trigger: select in field GROUP, search string ("china")

second trigger: select excluded in field GROUP

third trigger: select in field AREA, search string ("beijing"|"shanghai")

regards,

Edgar

View solution in original post

3 Replies
ekech_infomotio
Partner - Creator II
Partner - Creator II

Hi Eran,

you could make a 2 (3)-step selection:

first trigger: select in field GROUP, search string ("china")

second trigger: select excluded in field GROUP

third trigger: select in field AREA, search string ("beijing"|"shanghai")

regards,

Edgar

ekech_infomotio
Partner - Creator II
Partner - Creator II

... two other possibilities:

make bookmarks (without layout) for your complete selection and create an "apply bookmark" action

write a macro for your selection(s) and create a "external ==> run macro" action

regards,

Edgar

Not applicable
Author

GREAT! it works.

thank you very much.