topic Re: How to select multiple values in a field with actions ? in QlikView

How to select multiple values in a field with actions ?

Tue, 31 Aug 2010 16:29:26 GMT

Hi,

I'm trying to do something which seems very simple : I'm trying to select two or more values in a field. But I want to do this using actions (not Ctrl + Mouse button).

By example, suppose a Field 'MyField' such as :

LOAD * INLINE [
MyField
A
B
C
D
E
F
];

I just want to create an action which select B and E value. What is the correct syntax ?

Best regards

P.S : I'm working with QlikView 9 SR4 and SR5

How to select multiple values in a field with actions ?

Pablo_Robles — Tue, 31 Aug 2010 18:08:31 GMT

Hi Bertrand,

You can create an action, in a button or any other object, that selects several values. Follow the next steps:

1. Create a button (or other object that supports actions)

2. Create an action 'Select in a field'

3. Type the name of the field for the selection in the Field box

4. Type the value for the selection in Search string box

If you want select other value mantaining the previous selection, add a new action with Alternate select. Follow the next steps:

1. Create another action in the same button type 'Alternate select'

Repeat steps 3 and 4 from initial selection.

¡Voilá!

Best regards,

Pablo

Re:How to select multiple values in a field with actions ?

Wed, 01 Sep 2010 10:40:54 GMT

Hello !

Thanks for your answer,

I'm sorry, I don't understand what do you mean with "a button type 'Alternate select' " ? (maybe the "toggle select" action??)

Anyway I would like to select several values with only one action because I don't know how many value I will have to select at a time (it's stored in another field).

the toggle select action seems to be a good idea :

"Toggles between the current selection and the specified Field and Search String. In the Search String you can specify a search mask, e.g. (A|B) will select both A and B."

That's exactly what I want to do !

But I don't manage to find to right syntax to use in the search string box (of Toggle select action).
If I want to select 2009 and 2010 in a field, I've tried many syntaxs (such as (2009|2010), 2009|2010, '2009'|'2010', (same with '=' before)). But it doesn't works

Is someone have an idea ?

Best regards

Re:How to select multiple values in a field with actions ?

sunil2288 — Wed, 01 Sep 2010 11:04:28 GMT

HI BErtrand,

You can create a bookmark upon selection you made and can define an action upon the bookmark.

Hope it can Help you..

Regards,

Sunil

Re:How to select multiple values in a field with actions ?

Thu, 02 Sep 2010 08:20:12 GMT

Thanks for your answer,

but that's not exactly what I'm looking for.

Your solution would works if I know which selection I'm gonna make and if these selections are statics, but it's dynamical.

Any other ideas ?

Re:How to select multiple values in a field with actions ?

Wed, 16 Feb 2011 17:36:19 GMT

Hi,

It's not an idea, it's the solution

Try this : '(2009|2010)'

In my case, I use an Input Box link to myVariable to enter a list of value : 2009,2010

And I used a button with to action (toggle button) with the following expressions based on myField:

1) = '(' & GetFieldSelections(myField, '|') & ')' // to remove existing selection

2) ='(' & Replace(myVariable,',','|') & ')' // to apply my selection

Sébastien Fatoux

How to select multiple values in a field with actions ?

Wed, 16 Feb 2011 17:57:18 GMT

You can try this.


='('&Concat(Distinct Num1,'|')&')'

See example.

Re: How to select multiple values in a field with actions ?

Fri, 25 Nov 2011 10:41:48 GMT

Hi, could you explain me the Distinct function?

I want to do your method this action but in my "Num1" I have strings. And ones are simple word but someone are a string of couple words, for example: Num1=[string1, string2, st ri ng3, str ing4]. And this function work, but for only values of one words (string1, string2). How Can I do that for all?

How to select multiple values in a field with actions ?

Wed, 25 Apr 2012 10:08:47 GMT

Hi Cross

I have the same problem. But my values have a space in between their name. SO the logic

'(Product | Store Name)' is not working. What could be the possible solution

Re: How to select multiple values in a field with actions ?

Anonymous — Thu, 14 Jun 2012 16:44:02 GMT

You might've found the answer because this thread has been posted for awhile, but I'll give it a shot. If you have the space in between your values, try using double-quotes encapsulating those values, e.g.: ("Product"|"Store Name")

Cheers,

Anton

Re:How to select multiple values in a field with actions ?

Wed, 13 Feb 2013 16:36:57 GMT

Excellent Answer!

Re:How to select multiple values in a field with actions ?

Wed, 13 Feb 2013 16:37:04 GMT

Excellent Answer!

Re: How to select multiple values in a field with actions ?

Anonymous — Tue, 31 Oct 2017 06:32:08 GMT

Hi Anton

How do I add the double inverted commas dynamically. I've tried this expression, but does not work.

='(' & Chr(34) & Replace(myVariable,',', Chr(34) & '|' & Chr(34) ) & Chr(34) & ')'

Kind regards

Nayan

Re: How to select multiple values in a field with actions ?

Anonymous — Tue, 18 Sep 2018 05:03:00 GMT

If there are spaces in between field values,try below expression

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.