topic Set action on button in QlikView

Set action on button

Fri, 19 Mar 2010 09:30:50 GMT

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?

Set action on button

Fri, 19 Mar 2010 09:59:44 GMT

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.

Set action on button

Miguel_Angel_Baeyens — Fri, 19 Mar 2010 10:03:39 GMT

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.

Set action on button

Fri, 19 Mar 2010 10:22:14 GMT

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

Set action on button

Fri, 19 Mar 2010 10:44:40 GMT

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

Set action on button

Fri, 19 Mar 2010 10:48:33 GMT

Nah, already tried brackets 🙂

Set action on button

Fri, 19 Mar 2010 10:50:31 GMT

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.

Set action on button

Fri, 19 Mar 2010 10:57:50 GMT

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

Set action on button

Sat, 20 Mar 2010 18:21:50 GMT

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 🙂

Set action on button

nathanfurby — Thu, 10 Jun 2010 08:47:14 GMT

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)