Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

multi box button?

hi

when i made button from multi box.

if i have two dimnsions that first dimension is: CAMPAIGN='sam'

second dimension is: STATUS='eating' AND 'seating'

i made two select in fields but it doesnt work.

and if i want to write in the first dimension. CAMPAIGN NOT EQUAL 'sam' what i need to write in search string?

thank you

1 Solution

Accepted Solutions
Not applicable

multi box button?

Hi Eran,

Try to use '  ("Brand Marketing"|"Product Marketing") '

This works fine.

Kind regards,

Gert Jan

7 Replies
Not applicable

multi box button?

Hi Eran,

am not hundred % sure what you mean, but a multiple select in a multibox just press CTRL and select the other values.

In a search string I do not think it is possible to use a NOT EQUAL.

Hope this helps.

Greets Gert Jan

Not applicable

multi box button?

thank you but i meant how i do it in the button configaration, in the multi box i know how to do it.

      button properties -> Actions -> Add actions -> Action type asSelections -> Action as Select in field

     i tried do this but it doesnt work.  (Value1|Value2)


Not applicable

multi box button?

Hi Eran,

Sorry for the misunderstanding. I just put a button on my sheet and made a Selection via the button.

I select: action 'Select in Field',  Field 'Fieldname' , Search string '(102*|103*) (do not use = in front of your string) and by clicking on the button i do receive a multiple select with the values that fullfill the conditions.

To my knowledge I cannot however do a combination of 'AND' and 'NOT' in this string.

Hope this helps.

Highlighted
Not applicable

multi box button?

i dont know why it doesnt work.

maybe there is problem the way i am writing this:

(Faked Details|Two Users)

when i write every single one of them this is work.

i want to succeed this one first and then to learn how to choose everyone except this two conditions.(NOT)

Not applicable

multi box button?

Hi Eran,

Just a short remark I use QlikView 11 ir!

Kind regards,

Gert Jan

Not applicable

multi box button?

Hi Eran,

Try to use '  ("Brand Marketing"|"Product Marketing") '

This works fine.

Kind regards,

Gert Jan

Not applicable

multi box button?

OK its work, now if you idea or some direction how can i do NOT this two it will realy helpful.

thank you very much Gert Jan

Community Browser