topic Re: [ASK] Why triggers isn't activating? in QlikView

[ASK] Why triggers isn't activating?

Wed, 18 Dec 2013 05:20:01 GMT

Hello Qlikview'er..

Story :

1. i made a dashboard that use auto-show-hide sheet (detail below at the end of this post)

2. everysheet have same dashboard.

3. i add Sheet Event Triggers

3.1. (OnActivateSheet), actions select in field (field : row ; Search String : 1)

3.2. (OnLeaveSheet), actions select in field (field : row ; Search String : 2) //it activates the next data for next-show sheet that will use as a dimension

4. Only 1 sheet show for some periodic of time (seconds)

Problem :

triggers isn't activating, it shows like i didn't click on the show-sheet.

Question :

why is that happening?

and how to solve this?

i really appreciate some help

many thx before

------------------------

1. Detail

link source : [ASK] how to make auto show-hide sheet

i have worked with these in some time and take a conclution,

the formula that nitin gave only able to use if you have 60 vVarDur

where vVarDur = [total of sheet that you will use] * [duration of each variable to show]

but if you have more than 60 vVarDur, then you maybe need formula like this :

0. Max vVarDur=60*60=3600 (0-3599) //maximal vVarDur that can be used

1. Qlikview variable you need :

1.1. vModSec = mod((minute(now())*60)+Second(now()),vVarDur)

//vVarDur is total of sheet*duration@sheet that you will use

1.2. vModSecMul = [value_number] //duration of each sheet in second

2. Sheet Properties -> Conditional

2.1. =if($(vModSec)>(x*$(vModSecMul)) and $(vModSec)<=(y*$(vModSecMul)),1,0)

//x is the *number of previous sheet, y is the

*number of current sheet

*note :

if current sheet is your first sheet, then x=0 and y=1

if current sheet is your second sheet, then x=1 and y=2

.... and on ...

many thx for the clue

Re: [ASK] Why triggers isn't activating?

Wed, 18 Dec 2013 05:32:19 GMT

Which mode are you using to view your qlikview file?

Reason being, there are few actions/triggers which won't work in AJAX mode.

If you are using AJAX then you can refer to below url for further info on which Action/Trigger is supported in which mode

http://community.qlik.com/message/336101

Hope this helps!

Re: [ASK] Why triggers isn't activating?

Wed, 18 Dec 2013 05:40:01 GMT

i'm using desktop view

and total i have 10 sheets

but only show 1 sheet per-periodic of time (seconds), and the rest are hide until it time comes

when the sheet conditional is "always" ,trigger is doing fine by clicking every sheet i want to show

but when the sheet conditional is "Conditional" with formula i mentioned above, trigger is not working

it's like that i'm just watching the sheet but not activate the trigger

Re: [ASK] Why triggers isn't activating?

Wed, 18 Dec 2013 05:59:36 GMT

If possible can you post your sample app? so it will be easier to see the behaviour.

Re: [ASK] Why triggers isn't activating?

Wed, 18 Dec 2013 06:47:36 GMT

i'll edit the qvw file first, because it's confidential

anyway, can i put trigger in sheet conditional?

Re: [ASK] Why triggers isn't activating?

Wed, 18 Dec 2013 06:59:29 GMT

in the first post i've attached the files

hope u can help me

many thx

Re: [ASK] Why triggers isn't activating?

Wed, 18 Dec 2013 07:59:14 GMT

This is because the condition which you have specified for sheets, just "Opens" the sheets and not "Activates" them, hence the trigger for selecting value on activation of sheet doesn't work.

You need to add triggers for Activating the sheets first (On whatever condition you want), then the triggers for selecting value in row will automatically.

Re: [ASK] Why triggers isn't activating?

Wed, 18 Dec 2013 08:02:19 GMT

would you show me a sample please?

many thx before

Re: Re: [ASK] Why triggers isn't activating?

Wed, 18 Dec 2013 08:36:39 GMT

i have tried just now

but sheet number 2 doesn't change the row to "2"

i don't know what's wrong

i need a few more help please

many thx

Re: Re: Re: [ASK] Why triggers isn't activating?

Wed, 18 Dec 2013 08:50:44 GMT

i've tried once again with try-and-error mode

and i myself have no reason why it worked

thx for the clue

but i still want an explanation for this

*really confuse and my head almost explode