Re: Select In Field in Button Action - Qlik Community

manideep78 · ‎2021-03-31

Hi All,

Button >> Actions >> Select in Field

Field

Can we pass multiple fields here?

Search String

I know we can pass multiple values here.

Thanks

QFabian · ‎2021-03-31

Hi @manideep78 , you can create more than one action :

QFabian

manideep78 · ‎2021-04-01

is it possible to pass multiple fields within one select in field action?

i would to pass fields dynamically. search for a string in multiple fields dynamically.

QFabian · ‎2021-04-01

I think wih a macro you can do that, and then create one external macro action.

This could be a base , and you can add an array or something to produce the required automation

Sub SelectFields

ActiveDocument.Fields("Field1").Select "A"

ActiveDocument.Fields("Field2").Select "B"

ActiveDocument.Fields("Field3").Select "C"
End SUb

QFabian

manideep78 · ‎2021-04-01

Thanks for recommending the macro.

I'm not it will fit my requirement. here is my requirement

Inputbox = "Hello World"

List box(led checkboxes) with Field names as values(Title, Summary, Description) created with inline table.

**actual table have original columns**

*************

select any values from above list box

(Title) or (Title + Summary ) or ALL

then On click of a button, if hello world exists in either of the selected original columns then filter down to those rows and display in table box.

**** Dynamic search of a given string in selected fields and apply filter *****

manideep78 · ‎2021-04-02

My requirement is something similar like this:

In this post, @swuehl replied with the solution but it's not working for me.

Select In Field in Button Action