topic Re: OnActivate Sheet Event Triggers - I give up! :( in QlikView

OnActivate Sheet Event Triggers - I give up! :(

Tue, 10 Mar 2015 10:11:07 GMT

Hi All

Either I am misunderstanding the purpose of this or I have not stumbled across the correct syntax yet.

I have two sheets (labelled Fire and Medical).

I have a Field labelled EMERGENCY containing only two values (possible values Fire or Medical).

When I select the Fire sheet I want the value Fire in the EMERGENCY field to be selected by default (which would clear the value of Medical) and when I switch to the Medical sheet I want the value Medical in the EMERGENCY field to be selected (which would clear the value of Fire).

So far I have gone to Sheet Properties | Triggers | Sheet Event Trigger | OnActivateSheet | Add Action(s)

I have added the action 'Select in Field'

Under Field I have =EMERGENCY

Under Search String Medical

I have tried 'Medical' and "Medical" and various other things I can't recall. The HELP is less than helpful with regard to examples of Search String syntax etc.

Many thanks

Oli

Re: OnActivate Sheet Event Triggers - I give up! :(

Anonymous — Tue, 10 Mar 2015 10:15:30 GMT

Type this:

in Field --> EMERGENCY

in search string --> ='Medical'

and so on for the other sheet.

Marc.

Re: OnActivate Sheet Event Triggers - I give up! :(

aveeeeeee7en — Tue, 10 Mar 2015 10:17:53 GMT

You are doing it the Right way. If possible, kindly share the Application with reduced data.

Regards

Av7eN

Re: OnActivate Sheet Event Triggers - I give up! :(

aveeeeeee7en — Tue, 10 Mar 2015 10:19:51 GMT

Are you using 'Clear All' Trigger After Emergency - 'Medical' Trigger.

If so, than Promote your 'Clear All' Trigger.

Regards

Av7eN

Re: OnActivate Sheet Event Triggers - I give up! :(

Tue, 10 Mar 2015 10:34:33 GMT

Here is my test version.

Thanks

Oli

Re: OnActivate Sheet Event Triggers - I give up! :(

simenkg — Tue, 10 Mar 2015 10:37:46 GMT

In Field you should not have = first.

The '=' will tell the text input to evaluate the field value of the following field.

Just put EMERGENCY without the = and i should work.

Re: OnActivate Sheet Event Triggers - I give up! :(

Tue, 10 Mar 2015 10:42:30 GMT

Hi Simen

What a 'school boy' error!! I could kick myself.

I did have the '=' in the search string at one point, but I guess combined with the '=' in the field it stopped it working....

Thanks again.

Oli