topic Triggers on SheetActivation in QlikView

Triggers on SheetActivation

maxime66 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Qlikers

i've created a list of my Sheets Name and i check changes on the filed "onglet" to activate the selected sheet.

(Properties Of document / Triggers / Triggers for events on a field)

This part works well.

I also set a trigger on "RDV" sheet to select specific salesman.

When sheet "RDV" is selected i want "salesman" = "jon" (that works manually but not with the sheet list method below)

any ideas to fix this?

thx by advance.

Re: Triggers on SheetActivation

flipside — Tue, 21 Mar 2017 15:03:27 GMT

Could you remove the sheet trigger and add an extra action to your field trigger to set the salesman field with this expression ...

if(onglet='RDV','jon','')

flipside

Re: Triggers on SheetActivation

Anonymous — Tue, 21 Mar 2017 15:08:17 GMT

Think you need to create the variable salesman before hand. I tried by creating it in the script and it worked. Please find attchment.

Re: Triggers on SheetActivation

maxime66 — Tue, 21 Mar 2017 15:17:59 GMT

hi,

Actually i need Salesman to be really "selected" to filter all datas linked to him

NB : The Qvw file that i join, is just an exemple,

real Qvw file has 30 sheets and each one has diffrent triggers ...

Re: Triggers on SheetActivation

beck_bakytbek — Tue, 21 Mar 2017 17:22:21 GMT

Hi Maxime,

check this:

https://www.youtube.com/watch?v=OJgxnSKC3YM

https://www.youtube.com/watch?v=9vKN4-FgXZE

i hope that helps

beck

Re: Triggers on SheetActivation

Anonymous — Wed, 22 Mar 2017 07:49:24 GMT

AM unable to get your eact requirement. Can you please explain.

Re: Triggers on SheetActivation

yoganantha321 — Wed, 22 Mar 2017 10:14:43 GMT

Max,

I think you have used different dimensions in two sheets try with the same dimension so that it will be automatically selected in mentioned "RDV" sheet

Re: Triggers on SheetActivation

flipside — Wed, 22 Mar 2017 11:21:06 GMT

Hi Maxime,

Getting triggers to work exactly how you need them can be a bit tricky. What I think is happening is that although the field trigger and sheet trigger work independently, they don't work in combination.

If you are keeping the tab row, then you need to have both types of trigger set up. If not then you can probably avoid the use of sheet triggers. The field trigger needs to also select the relevant salesman, like my earlier code. If you have different values for the salesman field depending on the sheet chosen, you will need to use an if statement, or I would use a pick/match combination (much easier to read than an 'if') like this ...

=pick(match(onglet,'RDV','Actions'),'Jon','Jack')

What this does is look at the value of onglet and match it against the listed values RDV and Actions returning 1 or 2 if there's a match and zero if none found. It then picks value 1 or 2 from the list of salesmen names and this can be applied to the field salesman.

Hope this helps

flipside

Re: Triggers on SheetActivation

maxime66 — Wed, 22 Mar 2017 11:39:48 GMT

Hi Dave,

i'm gonna do that !

thank you

best regards

And thanks also to all of you

Re: Triggers on SheetActivation

Kushal_Chawda — Wed, 22 Mar 2017 11:42:16 GMT

Apply select in field trigger

Re: Triggers on SheetActivation

maxime66 — Thu, 23 Mar 2017 09:28:33 GMT

Hi,

i find another way (without modifying my sheet triggers)

Document Properties / Triggers / Field event triggers / field <onglet> / OnSelect / Execute macro : theFieldValues)

Sub theFieldValues

ActiveDocument.Sheets(ActiveDocument.Fields("id_onglet").GetPossibleValues.Item(i).Text).Activate

end sub

Works fine ! (as long as Qlik keeps Vba module in their plan )

Regards

Max.