topic NOT condition in Button? in QlikView

NOT condition in Button?

Thu, 02 Feb 2012 12:45:05 GMT

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

ekech_infomotio — Thu, 02 Feb 2012 13:01:34 GMT

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 — Thu, 02 Feb 2012 13:05:37 GMT

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

Thu, 02 Feb 2012 13:08:07 GMT

GREAT! it works.

thank you very much.