Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

OnActivate Sheet Event Triggers - I give up! :(

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

1 Solution

Accepted Solutions
Partner
Partner

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

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.

6 Replies
marcarreras
Valued Contributor

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

Type this:

in Field -->  EMERGENCY

in search string -->  ='Medical'

and so on for the other sheet.

Marc.

aveeeeeee7en
Valued Contributor III

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

Hi

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

Regards

Av7eN

aveeeeeee7en
Valued Contributor III

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

Hi

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

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

Regards

Av7eN

Not applicable

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

Hi

Here is my test version.

Thanks

Oli

Partner
Partner

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

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.

Not applicable

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

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