topic Re: Filter text field using variable input in QlikView

Filter text field using variable input

joss_g — Sat, 16 Nov 2024 17:43:56 GMT

Hello everyone,

I've got a database that contains a date, a text field (string), a label field (integer), and a result field (float). My first step was to plot an average of results where label = 1, for this I easily managed to do it by running Avg({<label={1}>}result) ... but this computes the average over all rows. Now, I'd like it to run only over certain rows for which the text field contains a specific keyword (to be entered by the user, it could be any word).

So I created a variable input called keyword and I'm trying to add to my formula this step that would say: fetch all text entries that contain this keyword and perform Avg({<label={1}>}result) for this selection.

Any thoughts on how to achieve that? I read about WildMatch and how to call a variable input '*$(keyword)*' but cannot figure out if that's what I should use and how to place it in the Avg() formula.

Many thanks 🙂

Re: Filter text field using variable input

Kushal_Chawda — Mon, 07 Dec 2020 22:27:56 GMT

@joss_g may be this

Avg({<label={1}, keyword_field = {"*$(keyword_variable)*"}>}result)

Re: Filter text field using variable input

SaintLouis — Tue, 08 Dec 2020 06:58:54 GMT

I've been playing around with filters and tried to filter a text variable to find all elements that matched partially the text input. ... If the text field is {{text_here}} and then you use the regex command in the provided box it will work, but that's a pain .

Re: Filter text field using variable input

brucewayn — Fri, 02 Dec 2022 12:45:34 GMT

Perfect no ads, and easy to understand I made crazy editing on it! The best thing is that there are tutorials on it to help you, it's great, even tutorials in the application! When you click on the magic wand to rate new projects there are montages ready! Even if sometimes there are bugs! Go to settings and say if there are problems I did it 2 3 times it solved them for me it's really great I advise you!!!!!?