Set action on button

[#1]

Hello,

I'm trying to make an action button where more than one field is selected.

Example:
When I push a button and set it to select a field name I can type in text. Now I want to set 2 different values. On push I get al employees from building A. Now I want to get al employees from building A en B. The button is now set to change the selected field to Building A. It does not work when I type in: Building A AND Building B

Can anyone tell me how to do this?

[#2]

When you use the Select in Field action, you can add multiple selections. Say you have A and B you want selected, then you enter in the Search string: (A|B).

However, I was unable to do this with a selections that have spaces in them. I tried adding ' and " but that doesn't work.

Samples that don't work:

('Building A'|'Building B')

("Building A"|"Building B")

Also added spaces and other signs, but it just didn't give the result I needed.

[Miguel_Angel_Baeyens]

Hi Mark,

Just and idea that worked for me in Set Analysis is using brackets instead of double quotes. But I haven't tested it yet.

[#4]

i am not clear whether you want to select two different field values in a field on single buttonclick or you want to select all the fieldvalues of two different fields on a singlebuttonclick .

pls be a bit more clear

thanks

[#5]

Hi Mark,

For selecting a field value having spaces in between just write the starting one or two characters or the first word of the field value followed by a * in the search string box. This should work fine

Regards

Joseph

[#6]

Nah, already tried brackets 🙂

[#7]

Yes, that works, but only if the first string of chars is unique. So it won't work if you have 'Building A' and 'Building B' as strings.

[#8]

Hi Mark,

In this case, just add a * in front of the second word.... Like if the field value to be selected is "Building B" then use *B in the search string box.

This gives you the selected field value.

Thank you

[#9]

I know, but the point is that there is no unique way to do this. If it fits the data though, it is of course a good way to fix this 🙂

[nathanfurby]

Yes it does appear that you cannot enter values which have spaces in them - seems a bit ridiculous.

I resolved the problem by creating two 'Toggle Select' actions and assign each of them one value:

I read somewhere else that you could add a Select in Field action with a blank Search String at the top of the Actions list to clear any previously selected fields. Not an issue for me as users do not have access to a List Box for those fields.

****************

Nope - I'm wrong. Just found the answer here:

http://community.qlik.com/forums/p/28917/111074.aspx

You can use the '?' character in the place of any spaces in values.

(Building?A|Building?B)