topic Re: Clear Field doesn't work in QlikView

Clear Field doesn't work

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

Hi guys,

I have a little problem, I created a button with there two actions in this order:

clear all field;
select max value of field A.

Now when I press the button never change.

For example, suppose the field has three values:

2015
2016
2017

and now 2015 is selected.

So when I press the button, the new selected value should be 2017, but the selected value remain 2015.

What's the problem?

I attach a very simple example.

Thanks to all

Re: Clear Field doesn't work

sunny_talwar — Wed, 27 Sep 2017 15:15:43 GMT

Change select in field search string for years to this

=Max({1}years)

Re: Clear Field doesn't work

swuehl — Wed, 27 Sep 2017 15:16:38 GMT

As search string, use

=Max({1}years)

You may or may not want to remove the first action, depending on your complete requirements.

Re: Clear Field doesn't work

marcus_malinow — Wed, 27 Sep 2017 15:18:09 GMT

Not sure why your Clear All action is failing, but I can confirm that I am also experiencing this.

Instead I'd suggest:

- remove the Clear All Action

- change the expression in your 'Select In Field to =max({1} years)

Re: Clear Field doesn't work

swuehl — Wed, 27 Sep 2017 15:31:30 GMT

Well, you might expect that the actions are executed one after the other and that the second action's search string expression is evaluated based on the selection status after the first action finished - but that's unfortunately not true, AFAIK.

I believe, the context of the search string evaluation is determined prior the execution of any action.

Re: Clear Field doesn't work

marcus_malinow — Wed, 27 Sep 2017 15:33:28 GMT

Aah, a mystery solved

I very rarely use triggers for selections so hopefully will avoid this in my day job!