Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
Contributor II

NOT condition in Button?

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

3 Replies
ekech_infomotio
Contributor II

NOT condition in Button?

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
Contributor II

NOT condition in Button?

... 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

NOT condition in Button?

GREAT! it works.

thank you very much.