topic Re: Triggers on Alternate State in QlikView

Triggers on Alternate State

ali_hijazi — Thu, 18 Jun 2015 09:44:15 GMT

Hello

Got a document in which the selection on the Date field sets a variable called vFromDate to a value = num(daystart(monthEnd(Date))

now I got the same list box for Date but put in an alternating state called MAIN

I want the selection on this list box to set the same variable vFromDAte to the same expression but calculated in state MAIN

I added another action and selected the STATE MAIN but the variable vFromDATE only changes on the inherited state

Please advise

swuehl — Thu, 18 Jun 2015 09:55:36 GMT

Try as variable definition

num(daystart(monthEnd(only({MAIN} Date)))

ali_hijazi — Thu, 18 Jun 2015 10:25:10 GMT

I did but it didn't work

it is changed only selections made on original state

swuehl — Thu, 18 Jun 2015 10:33:19 GMT

If I test a OnSelect trigger, it's getting fired also when selecting on a field list box in alternate state.

I am on 11.20 SR11, which version are you running.

ali_hijazi — Thu, 18 Jun 2015 10:37:32 GMT

I'm using 11.2 SR8

ali_hijazi — Thu, 18 Jun 2015 10:46:47 GMT

what I want is to give different values for the same variable depending on the selection made on Date in the diverse states

if in original state I select 2014 feb the variable should take feb 2014

whereas if I select 2015 feb from the list box which got an alternate state I want the same variable to take feb 2015

knowing that the 2 listboxes are in different tabs (sheets)

swuehl — Thu, 18 Jun 2015 11:09:47 GMT

I currently don't know how this should work out.

Maybe you can do it another way: Create an OnActivate sheet trigger for both sheets that is setting the variabel to either

='=num(daystart(monthEnd(Date))'

='=num(daystart(monthEnd(only({MAIN} Date)))'

So you are using two different definitions for your single variable depending on the sheet you are working.