topic Re: Select In Field in Button Action in QlikView

Select In Field in Button Action

manideep78 — Wed, 31 Mar 2021 20:42:05 GMT

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 — Wed, 31 Mar 2021 21:23:47 GMT

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

manideep78 — Thu, 01 Apr 2021 12:50:28 GMT

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 — Thu, 01 Apr 2021 13:34:47 GMT

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

manideep78 — Thu, 01 Apr 2021 15:29:07 GMT

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 — Fri, 02 Apr 2021 15:26:44 GMT

My requirement is something similar like this:

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