topic Re: Create a button that selects multiple selections from one field in QlikView

Create a button that selects multiple selections from one field

peterderrington — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm sure there must be an easy way to do this but i can't seem to find it.

I want to create a button that when pressed selects a predefined list of items that are contained in a field.

I have tried to use:

=GetFieldSelections('19 Albion Road','2 Manor Walk Benton','2 Swarland Avenue','31 West Farm Avenue','381 West Farm Avenue','49 Marine Avenue Surgery','69, Park Parade','93, Park Road')

but to no avail.

The list contains approx 100 items (the whole field contains over 400).

Any ideas?

Thanks in advance.

Peter

Re: Create a button that selects multiple selections from one field

sunny_talwar — Fri, 23 Jun 2017 13:16:00 GMT

Try this with select in field action

Field

FieldName

Search String

Re: Create a button that selects multiple selections from one field

peterderrington — Fri, 23 Jun 2017 14:32:13 GMT

Thanks for this Sunny.

I've had a few problems with the difference between QlikViews speech marks and words:

QlikView: ("19 Albion Road"|"2 Manor Walk Benton")

Word: (“19 Albion Road”|”2 Manor Walk Benton”)

It wouldn't see the list when i imported it in from Word so I've had to go through each one and reapply the speech marks.

I'm still having problems with it accepting my current full selection but i'm assuming thats down to either a syntax error (i might have missed a speech mark) or if theres a limit to the number of selections that can be in the list.

Re: Create a button that selects multiple selections from one field

sunny_talwar — Fri, 23 Jun 2017 14:38:28 GMT

I'm still having problems with it accepting my current full selection but i'm assuming thats down to either a syntax error (i might have missed a speech mark) or if theres a limit to the number of selections that can be in the list.

Difficult to say without having a look, but in general this is the syntax for multiple selections with spaces in the values

("Text 1"|"Text 2"|....)

Re: Create a button that selects multiple selections from one field

ellwoodis — Wed, 28 Aug 2019 20:37:19 GMT

That gives me

Error in Expression: ')' expected

Another idea?

Re: Create a button that selects multiple selections from one field

cvenancio15 — Thu, 12 Dec 2019 15:44:44 GMT

I have the same problem. Does anyone know the solution?

Re: Create a button that selects multiple selections from one field

Almen — Fri, 13 Dec 2019 11:08:00 GMT

The Qlik-Dashboard Bundle provides you with a button (Called Button for Navigation) that you can define to do either Action or Navigation tasks. Select Action and look for Select Multiple Values in a Field.

Re: Create a button that selects multiple selections from one field

cvenancio15 — Fri, 13 Dec 2019 11:13:10 GMT

Hi Almen,
Yes, it's true, but I have a problem when I try to add multiples values.
("Lisbon "|"Madrid"|"Paris" ) I try this form, but give me error "expected ()"

Re: Create a button that selects multiple selections from one field

Almen — Tue, 17 Dec 2019 10:55:16 GMT

Did you try using the Navigation Button extension? Because it specificially asks you to use ; as a separator.