topic Re: Triggers Question. in QlikView

Triggers Question.

MuraliPrasath — Wed, 29 Jul 2015 05:37:00 GMT

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?

Re: Triggers Question.

sushil353 — Wed, 29 Jul 2015 05:46:57 GMT

Hi,

You can use sheet based trigger:

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

HTH

sushil

Re: Triggers Question.

Kushal_Chawda — Wed, 29 Jul 2015 05:47:32 GMT

like this

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

Re: Triggers Question.

tresB — Wed, 29 Jul 2015 05:47:58 GMT

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

Re: Triggers Question.

ToniKautto — Wed, 29 Jul 2015 05:55:01 GMT

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.

Re: Triggers Question.

MuraliPrasath — Wed, 29 Jul 2015 05:55:46 GMT

It's not working guys. It is correct ?

Re: Triggers Question.

MuraliPrasath — Wed, 29 Jul 2015 05:59:43 GMT

Hi Toni,

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

Re: Triggers Question.

avinashelite — Wed, 29 Jul 2015 06:03:02 GMT

please find the attachment for the solution

Re: Triggers Question.

tresB — Wed, 29 Jul 2015 06:06:13 GMT

Field name should be - ShipmentStatus

and Search String - COMPLETED

Re: Triggers Question.

MuraliPrasath — Wed, 29 Jul 2015 06:18:11 GMT

Hi Avinash,

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

Re: Triggers Question.

avinashelite — Wed, 29 Jul 2015 06:18:53 GMT

use alternate states on that particular sheet

Re: Triggers Question.

avinashelite — Wed, 29 Jul 2015 06:22:22 GMT

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

Re: Triggers Question.

MuraliPrasath — Wed, 29 Jul 2015 06:31:25 GMT

thanks you so much.

Alternate States in QlikView - YouTube

Re: Triggers Question.

MuraliPrasath — Wed, 29 Jul 2015 06:47:43 GMT

thank you once again 🙂

Re: Triggers Question.

avinashelite — Wed, 29 Jul 2015 07:17:18 GMT

your always welcome