topic Re: Sheet Event Trigger in QlikView

Sheet Event Trigger

Tue, 27 Dec 2011 10:04:26 GMT

Could you help me with the following selection:

I'm trying to select only values for PL_No_ that start with '61'

For this I added an Action under Sheet Properties > Sheet Event Triggers > OnActiveSheet > Select in Field:

Field: PL_No_

Search String: =PL_No_ LIKE '61*'

But this is obviously not working; Can someone tell me what is wrong?

Thxs

Sheet Event Trigger

Miguel_Angel_Baeyens — Tue, 27 Dec 2011 10:12:01 GMT

Hi,

Search String would just be

61*

That should work fine.

Hope that helps.

Miguel

Re: Sheet Event Trigger

Tue, 27 Dec 2011 10:14:14 GMT

Thanks a lot for the fast response, it indeed worked. Is it also possible to not allow users to clear this selection?

Sheet Event Trigger

Miguel_Angel_Baeyens — Tue, 27 Dec 2011 10:21:40 GMT

Hi,

Yes, add a new action below this one: Action Type Selection, Lock Field, and the field you want to keep locked.

Regards.

Miguel

Re: Sheet Event Trigger

Tue, 27 Dec 2011 10:37:57 GMT

Thanks for the reply.

This is not exactly what I'm looking for, because I still want to be able to make 'subselections' between the different 61* results. Now I can only select all 61* and nothing else. I want to be able to select only 610 and not 611 or 612

Is this possible?

Sheet Event Trigger

Miguel_Angel_Baeyens — Tue, 27 Dec 2011 10:45:25 GMT

Hi,

That's not possible since locking a value in a field actually locks that value, you cannot do a "variable lock". But what you can do is to create a "parent" field in the script, creating a new field that keeps only the two first digits of that field, and do the lock on that field. Using the associative logic, once this parent field is locked, you will be able to select 610 or 611, but not 600 ot 607.

Hope that helps.

Miguel

Re: Sheet Event Trigger

Fri, 07 Sep 2012 07:51:18 GMT

Hi Miguel.

I'm trying to do a simular solution but when I enter the sheet I would like to have the last year and the last month. I have a filed "year" and "month" and I've tried to use settings > sheet propertiies > OnActivateSheet > Add Action > Select in Field > Field =Year Search String =max(Year).

It doesn't work. Du you have a suggestion have to solve it?

Thanks!

Re: Sheet Event Trigger

Miguel_Angel_Baeyens — Fri, 07 Sep 2012 08:38:33 GMT

Hi,

Which version of QlikView are you running? Remove the "=" sign before the field name (Year). The search string should work fine (it's working fine here running versions 10 and 11).

Hope that helps.

Miguel

Re: Sheet Event Trigger

Fri, 07 Sep 2012 09:02:50 GMT

I'm using verion 10 and yes it's working now. But if I would like to have the latest year and the previous month, how to do? If I put two action, one for =max(year) and one for =max(month -1), it's only one of them that is working.

Re: Sheet Event Trigger

Miguel_Angel_Baeyens — Fri, 07 Sep 2012 09:24:29 GMT

Hi,

Try instead

=Max(Month) -1

Hope that helps.

Miguel

Re: Sheet Event Trigger

Fri, 07 Sep 2012 09:55:23 GMT

But how to use that I would like to have triggers on two fields? If I have the one with "year" and the otherone with previous "month" it's only one of the triggers that is working, the last one sorted in the Actions windows. See attached picture.