topic Trigger to Select in More than One Field in QlikView

Trigger to Select in More than One Field

Anonymous — Thu, 26 Nov 2015 16:22:57 GMT

Hi Guys,

Is it possible to set up Triggers on Sheet Activation so it makes selections in more than one Field?

For instance:

Select in Field:

FIELD: ALPHABET

SEARCH STRING: A

Lock Field:

FIELD: ALPHABET

Then Another Select in Field:

FIELD: NUMBER

SEARCH STRING: =Max(Number)

That way when the user opens the specific sheet the document already has the values of A and the maximum number selected?

I've seen other discussions about two strings within the one field but I am struggling with selecting values in two differing fields.

Regards.

Re: Trigger to Select in More than One Field

swuehl — Thu, 26 Nov 2015 16:52:25 GMT

You can use more than 1 action with one trigger. Just add actions as needed in the dialog.

Re: Trigger to Select in More than One Field

Anonymous — Thu, 26 Nov 2015 16:56:28 GMT

Hi Swuehl,

I have tried that but it only seems to be picking up the first Select in Field and ignoring the second.

Re: Trigger to Select in More than One Field

t_chetirbok — Thu, 26 Nov 2015 17:04:51 GMT

Hi!

Re: Trigger to Select in More than One Field

swuehl — Thu, 26 Nov 2015 21:04:40 GMT

I believe it should perform both, if the selection in second field is done properly and won't result in an incompatible set.

Could you upload a small sample QVW that demonstrates what you are trying to achieve?

Re: Trigger to Select in More than One Field

roger_stone — Thu, 26 Nov 2015 22:29:57 GMT

I've noticed that QlikView doesn't always respond to triggers correctly when developing the app. If you insert a trigger, save the document before testing the trigger. That usually works fine.

Re: Trigger to Select in More than One Field

swuehl — Thu, 26 Nov 2015 22:40:12 GMT

Ok, one issue could be that your second selection will try to select max(Number) of the possible Number values before the first selection is made.

Try

Then Another Select in Field:

FIELD: NUMBER

SEARCH STRING: =Max({<ALPHABET = {A}>} Number)

Re: Trigger to Select in More than One Field

Anonymous — Fri, 27 Nov 2015 11:28:48 GMT

That's it working now.

Cheers.