topic Using 'Select in field' action for multiple selections in QlikView

Using 'Select in field' action for multiple selections

Tue, 04 May 2010 14:45:45 GMT

Hi,

I am using sheet actions to pre-select some fields on a particular sheet when the user opens it.

This works fine when I want to make a single selection (e.g. Field=Colour, Search String = 'Yellow').

However I can't figure out how to make multiple selections in the same field (something like Search String = 'Yellow','Blue'). The help manual clearly indicates this should be possible:

Select in Field: "Selects the values and fields that are specified. In the Search String you can specify a search mask, e.g. (A|B) will select both A and B."

I can't for the life of me figure out how to write this, I can't seem to get the syntax right. I have tried all of the following:

='Yellow','Blue'

=Yellow,Blue

=('Yellow','Blue')

=('Yellow'|'Blue')

=('Yellow'&'Blue')

=('Yellow' and 'Blue')

Anyone got this to work? Other threads raise this question but the only answers seem to be 'use a macro' (http://community.qlik.com/forums/p/23382/89368.aspx#89368). I'd rather not use macros jsut for this as I have not used macros so far, and would be good to keep consistent.

Thanks!

Using 'Select in field' action for multiple selections

Tue, 04 May 2010 14:50:53 GMT

As you have use select in field to select one value . After that use toggle select to select the othere values . One toggle select for one value and this is how you will be able to select multiple values.

Using 'Select in field' action for multiple selections

Tue, 04 May 2010 14:54:26 GMT

Rahul is correct..............

However..........

(YELLOW|BLUE) also works, no equals sign, no quotes, but include the brackets.

Using 'Select in field' action for multiple selections

Tue, 04 May 2010 15:04:34 GMT

Thanks Nigel,

I obviously didn't hit on that combination!

Note to others aswell: don't use a preceeding equals sign, this also breaks it.

Using 'Select in field' action for multiple selections

Thu, 22 Jul 2010 21:50:44 GMT

My requirement is a bit trickier. I have to select all values which do not contain 'QA*' as below

=not(wildmatch(Operation,'QA*'))

I can of course list all values in Operation which is not equal to QA like (FT|FT1|FT2|WS1|WS2). However, Operation is a dynamic list and I don't want to add a value whenever a new operation comes in.

Any ideas ?

Using 'Select in field' action for multiple selections

Wed, 12 Jan 2011 18:51:52 GMT

I have a field with spaces, say 'bla bla bla'. And the values it caointains have also spaces, say 'a b c' 'd e f' 'g h i' 'j k l'. My intention is to create a button that selects: 'a b c' 'd e f' 'g h i'

I've tried

( a b c | d e f | g h i )

( 'a b c' | 'd e f' | 'g h i' )

( [a b c] | [d e f] | [g h i] )

but it doesn't work.

Someone knows why??

Using 'Select in field' action for multiple selections

Fri, 11 Feb 2011 19:20:38 GMT

I think there are two (well, probably more but here are two) ways to do this:

1. Create a button with a "Select in Field" action. Have it select "a b c" (no quotes) in your field. Then create two more "Toggle Select" actions on that same button to select "d e f" and "g h i", respectively. Again, no quotes.

2. Create one button that does a "Select in Field" action. Put this in the "Search String" box: (a*b*c|d*e*f|g*h*i)

Approach 2 will work but you have to be careful since you're using wildcards. Sometimes I used this to select multiple first name / last name combinations.

Just a thought.

Chris

Using 'Select in field' action for multiple selections

Thu, 17 Mar 2011 15:15:55 GMT

Anthony,

did you find solution? I've got same issue.

Regards,

Monika

Using 'Select in field' action for multiple selections

tanelry — Fri, 18 Mar 2011 10:30:31 GMT

> My requirement is a bit trickier. I have to select all values which do not contain 'QA*' as below
=not(wildmatch(Operation,'QA*'))

You can use bookmark instead of direct selection.

Clear all selections and in a list box of field "Operation" make selection as above or more simple:
=not Operation like 'QA*'
Add a bookmark to be applied "on top" of current selections, without layout state.
Now you can use this bookmark in actions to make selection.

Bookmark is also useful solution for other "tricky" examples brought up in this thread.

Using 'Select in field' action for multiple selections

Fri, 15 Apr 2011 11:22:54 GMT

Im having the same problems. I can select the appropriate fields with the | symbol, but if the value you are trying to select contains a space, it falls over.

VERY ANNOYING INDEED

Using 'Select in field' action for multiple selections

tanelry — Fri, 15 Apr 2011 13:18:21 GMT

In QV10 you can use double quotes ("A B"|"C D").
But not in QV9 though. Use bookmark.

Using 'Select in field' action for multiple selections

Wed, 06 Jul 2011 14:19:41 GMT

Hi,

It seems to be common problem for QlikView developers. I tried all alternative solutions mentioned above.But unfortunately I could not achive selecting two values.

Fist of all I am using V9.

In my case I am trying to select multiple values of a time dimension. the values are assigned to two different varaibles. $Var1 and $Var2

In "Select in Field" box I have tried If I use only one varaible like ($Var1) it works. But I could nort find a way to select two.

I guess the reason is the date format of the field.

Does any one has an idea?

Best regards

Using 'Select in field' action for multiple selections

Fri, 23 Dec 2011 10:11:44 GMT

I just love this forum - thank you guys for all the help 🙂

Re: Using 'Select in field' action for multiple selections

Anonymous — Tue, 12 Aug 2014 12:46:53 GMT

If you have spaces then Tanel's solution for QV10 works well. This also works in QV11. Use double quotes.

"In QV10 you can use double quotes ("A B"|"C D")...".

Re: Using 'Select in field' action for multiple selections

Wed, 25 Feb 2015 09:35:49 GMT

Hi Anthony,

You can give select in field for the string 'QA' first and then give select excluded for the same field which results in selecting all values other than 'QA'.

I hope this helps

Re: Using 'Select in field' action for multiple selections

durgabhavani — Tue, 30 Jun 2015 03:43:29 GMT

Help me to get display the result based on the select in field value. suppose my field contains yellow red orange, if i click on yellow i need to get yellow result, if i click on red i need to get only red value.

Please help me.

Re: Using 'Select in field' action for multiple selections

jrdunson — Thu, 07 Jan 2016 20:37:51 GMT

Seems to work, when I do two values (A|B), but not three or four! Any suggestions?

It won't work with: (A|B|C|D)

Re: Using 'Select in field' action for multiple selections

jafari_ervin — Mon, 11 Jan 2016 14:05:04 GMT

using double quotes like this

( "a b c" | "d e f" | "g h i ")

Re: Using 'Select in field' action for multiple selections

Anonymous — Thu, 21 Dec 2017 13:49:31 GMT

Can someone in here perhaps help me with this thread?

Need to select a set of values in a list box, using a button action.

Re: Using 'Select in field' action for multiple selections

Anonymous — Thu, 20 Sep 2018 05:57:45 GMT

Below expression will work even for more than two values(Tried and tested)

in my case I wanted to select values like 'Level 0' ,'Level 1' ,'Level 2' from Level field ,

so if you want to select multiple values say Level 0 and Level 1 your o/p should be shown like this

("Level 0"|"Level 1")

to show o/p like use below expression

='('&' " '&Concat(distinct Level,'"|"')&' " '&')'

You can apply above expression as per your requirement ,and this will work smoothly.