Create a Variable for filter a field of Table

[#1]

Hi All,

it's possibile to create a Input Variable to filter a Table, see the example of my ideal results.

[tresesco]

It's possible. But why that way? You can allow users to select the filed value from the field listbox itself. And may be can capture the selection in a variable if needed defining your variable like:

VariableFieldA= Field1

And yes, always try to post a sample along with your query so that people can work on that and you get faster resolution.

[#3]

I have some tables with the total data . A user through the input variables must be able to filter the table for the value or set of values

[susovan]

Hi,

You can try this.

=Only({<Filed1 = {'A'}>}Filed1)

[#5]

I need to dynamic filter with a varible

[susovan]

Hi paolo,

Try this.

=only({<Field1={"$(vFilter)"},Field1={'A'}>}Field1)

Here vFilter is variable name,

and variable definition is vFilter=Field1

[tresesco]

PFA

Used Exp:       Sum({<Notification={'$(vInput)'}>}1)

[#8]

Hi tresesco,

this is the best answer , but I will table its total data filter is not necessary to create a new input data table Use.

[tresesco · Accepted solution]

May be using a trigger like in attached.

[#10]

that's it