topic Dynamic filter in QlikView

Dynamic filter

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

can I create a dynamic filter with the following features:

I can select the field on which the condition is applied;
I can select the operator;
I can select the value;

Let me do a little example:

supposed to have these three field:

age - integer
degree - string
salary - real

Now I want select all people who are older than 35 (age > 35), after that I want do a new filter and I want select people who are master degree (degree = 'master degree').

I know that I can create an input field where I can insert the value, but I want change the field and the operator too.

Re: Dynamic filter

Miguel_Angel_Baeyens — Tue, 03 Jul 2018 08:23:42 GMT

You can use variables and input boxes for each of the three field, operator, value, and based on that combination, trigger an action using another text object or a button, or even an OnChange trigger.

You can also use constraints in the input box to make sure the values input match the contents of a field or do not exceed a threshold, etc.

Re: Dynamic filter

Anonymous — Wed, 04 Jul 2018 14:28:47 GMT

I created two multi-selection field with predefined value for field and operator, and one input box where the user can insert the value.

When user select value inside multi-selection field, through trigger I update the value of v_fieldName and v_operator variables.

Then I created a button and when I press the button I want select the value inside the field.

The first problem is inside the Action -> Select on Field -> Field, I put =$(v_fieldName), but it doesn't work

Secondly how can I use the operator?

I think about something like this:

only({<$(v_fieldName) >= $(v_value) >}$(v_fieldName))

but how can I change '>=' with the value inside v_operator?

Or maybe there is a best way?

Re: Dynamic filter

Gysbert_Wassenaar — Wed, 04 Jul 2018 14:38:23 GMT

Like this: only({<$(v_fieldName) = {"$(v_operator) $(v_value) "}>} $(v_fieldName))

Re: Dynamic filter

Anonymous — Wed, 04 Jul 2018 15:24:05 GMT

I don't know why, but it doesn't work

Re: Dynamic filter

Gysbert_Wassenaar — Wed, 04 Jul 2018 15:41:22 GMT

See attached example