Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Hi Eran,

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

This works fine.

Kind regards,

Gert Jan

View solution in original post

7 Replies
Not applicable
Author

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
Author

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
Author

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.

Not applicable
Author

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
Author

Hi Eran,

Just a short remark I use QlikView 11 ir!

Kind regards,

Gert Jan

Not applicable
Author

Hi Eran,

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

This works fine.

Kind regards,

Gert Jan

Not applicable
Author

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