topic Re: Create a Variable for filter a field of Table in QlikView

Create a Variable for filter a field of Table

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

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

Re: Create a Variable for filter a field of Table

tresB — Mon, 06 Jun 2016 10:03:32 GMT

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.

Re: Create a Variable for filter a field of Table

Mon, 06 Jun 2016 10:06:54 GMT

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

Re: Create a Variable for filter a field of Table

susovan — Mon, 06 Jun 2016 10:20:39 GMT

Hi,

You can try this.

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

Re: Create a Variable for filter a field of Table

Mon, 06 Jun 2016 10:53:03 GMT

I need to dynamic filter with a varible

Re: Create a Variable for filter a field of Table

susovan — Mon, 06 Jun 2016 11:41:49 GMT

Hi paolo,

Try this.

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

Here vFilter is variable name,

and variable definition is vFilter=Field1

Re: Create a Variable for filter a field of Table

tresB — Mon, 06 Jun 2016 11:52:16 GMT

PFA

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

Re: Create a Variable for filter a field of Table

Mon, 06 Jun 2016 12:38:02 GMT

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.

Re: Create a Variable for filter a field of Table

tresB — Mon, 06 Jun 2016 13:44:05 GMT

May be using a trigger like in attached.

Re: Create a Variable for filter a field of Table

Mon, 06 Jun 2016 13:55:23 GMT

that's it