Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

How to select multiple values in a field with actions ?

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

1 Solution

Accepted Solutions
Highlighted
Not applicable

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

Hi,

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

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

View solution in original post

13 Replies
Highlighted
Partner
Partner

How to select multiple values in a field with actions ?

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

Highlighted
Not applicable

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

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

Highlighted
sunil2288
Contributor III

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

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

Highlighted
Not applicable

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

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 ?

Highlighted
Not applicable

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

Hi,

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

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

View solution in original post

Highlighted
Not applicable

How to select multiple values in a field with actions ?

You can try this.


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


See example.

Highlighted
Not applicable

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

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?

Highlighted
Not applicable

How to select multiple values in a field with actions ?

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

Highlighted
awqvuser
Contributor

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

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