Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
it's possibile to create a Input Variable to filter a Table, see the example of my ideal results.
May be using a trigger like in attached.
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.
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
Hi,
You can try this.
=Only({<Filed1 = {'A'}>}Filed1)
I need to dynamic filter with a varible
Hi paolo,
Try this.
=only({<Field1={"$(vFilter)"},Field1={'A'}>}Field1)
Here vFilter is variable name,
and variable definition is vFilter=Field1
PFA
Used Exp: Sum({<Notification={'$(vInput)'}>}1)
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.
May be using a trigger like in attached.
that's it