Filtering a record set based on a variable input

[timwhite]

I'd like to offer users the option of inputting a value to a variable text box and have the system update the filters so that it only shows records that have a value greater than the variable.  Is this possible?  I have the E-mergo triggers functionality installed, so I can trigger an event on the change of a variable, but I can't see the option to update the filter accordingly.

[CELAMBARASAN]

Hi @timwhite 

I think you need a solution that will help applying the selection in a field using E-mergo trigger.

Please refer Qlik+Sense+Search+Cheat+Sheet+en-US.pdf (Qlik Sense Cheat Sheet version 2.0 - Qlik Community - 1667455) for understanding the search criteria in Qlik Sense.

For your case refer the Numeric Search.

Hope it helps.

Regards

Celambarasan

[Lech_Miszkiewicz · Accepted solution]

Hi @timwhite 

There is no point using 3rd party extensions which as you can imagine dont have official Qlik support.

I suggest you just use regular variable input and button to apply selection on field based on action from "Select values matching search..."

cheers

[timwhite]

@Lech_Miszkiewicz Thank you!!  

Is there syntax that would allow me to filter to a set that is greater than one variable and less than another?

[Lech_Miszkiewicz · Accepted solution]

Hi @timwhite 

of course

='>=$(=vInput)<=$(=vInput2)'

where you have 2 variables vInput and vInput2 - you can create and name them as you wish