Solved: Re: Triggers Question. - Qlik Community

MuraliPrasath · ‎2015-07-29

Hi,

How to do force selection field on particular sheet? When the user clicks on sheet then the particular field (Approved) should select by default.

Need Help?

avinashelite · ‎2015-07-29

Please find the attachment for the solution:

To create alternate state, go to >document properties >general> Alternate state> and add one

And now in the sheet properties select the alternate state you have created and in the sheet properties > triggers> select the same alternate state ..this should work

View solution in original post

sushil353 · ‎2015-07-29

Hi,

You can use sheet based trigger:

Go to Settings> sheet property > Triggers> OnActivateSheet> Action Type (Selection )> Select in field

HTH

sushil

Kushal_Chawda · ‎2015-07-29

like this

Go to that sheet->sheet properties-> Add action-> Select in Field

tresesco · ‎2015-07-29

Right click on the sheet->Properties->OnActivateSheet->Actions->Selection->Select in field ...

ToniKautto · ‎2015-07-29

I just want to add to the above OnActivate trigger advise that selections are made in the data model, so even if the selection is made on a sheet if will affect all objects int he application.

MuraliPrasath · ‎2015-07-29

It's not working guys. It is correct ?

MuraliPrasath · ‎2015-07-29

Hi Toni,

I just want the selection on only one sheet. How to achieve this?

avinashelite · ‎2015-07-29

please find the attachment for the solution

tresesco · ‎2015-07-29

Field name should be - ShipmentStatus

and Search String - COMPLETED

MuraliPrasath · ‎2015-07-29

Hi Avinash,

This is affecting all other sheets also. It should apply only one sheet. Help me?