topic Re: Filtering a record set based on a variable input in App Development

Filtering a record set based on a variable input

timwhite — Fri, 15 Aug 2025 02:00:26 GMT

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.

Re: Filtering a record set based on a variable input

CELAMBARASAN — Fri, 15 Aug 2025 02:10:30 GMT

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

Re: Filtering a record set based on a variable input

Lech_Miszkiewicz — Fri, 15 Aug 2025 02:21:53 GMT

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

Re: Filtering a record set based on a variable input

timwhite — Fri, 15 Aug 2025 03:02:40 GMT

@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?

Re: Filtering a record set based on a variable input

Lech_Miszkiewicz — Fri, 15 Aug 2025 05:40:20 GMT

Hi @timwhite

of course

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

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