Alternate States - Field Event Triggers

Wed, 06 Jun 2012 21:50:38 GMT

Hello,

This is my inline table:

TimeExpressions, TimeYear, TimeMonth

Year over Year, sYearOn, sMonthOff

Month over Month, sYearOff, sMonthOn

Custom State, sYearCustom, sMonthCustom

These are the Variables:

SET sYearOn = =max({<Year=A::Year>} Year)-1

SET sYearOff = ='=sum({<Year=A::Year>}1)'

SET sYearCustom = ='=sum({<Year=B::Year>}1)'

SET sMonthOn = =max({<Month=A::Month>} Month)-1

SET sMonthOff = ='=sum({<Month=A::Month>}1)'

SET sMonthCustom = ='=sum({<Month=B::Month>}1)'

I have 2 Alternate States, "A" and "B". Each state has its own Year and Month list box.

I also have a "TimeExpressions" list box I created in the Inline table. (Make sure to set the TimeExpressions list box to Alternate State "A")

Under Field Event Triggers located at : Settings->Document Properties->Field Event Triggers->Year Field & Month Field

For the Year Field Event Trigger I set:

OnSelect->Edit Actions->

Actions : Select in Field

Field : Year

Alternate State : B

Search String : =$(=TimeYear)

For the Month Field Event Trigger I set:

OnSelect->Edit Actions->

Actions : Select in Field

Field : Month

Alternate State : B

Search String : =$(=TimeMonth)

The way this works is when I select values in the list box called "TimeExpressions". I can click on Year over Year and all my values from State "A" Year and State "A" Month are transfered to State "B" Year and State "B" Month, minus 1 year.

It works the same way with Month over Month but the Year stays the same and the Month goes back 1 month.

The issue is with the Custom State Selection, I'd like it to simple stop transfering the values from State A to State B and allow me to click my own custom field values in State B.

What's odd is this:

SET sMonthOff = ='=sum({<Month=A::Month>}1)'
(This copies the same value from State "A" Month to State "B" Month,

SET sMonthCustom = ='=sum({<Month=B::Month>}1)'

(This SHOULD copy the same value from State "B" Month to State "B" Month, or leave it the same, when I place this value directly into the Field Event Trigger without a variable it works!)

Is there a different syntax I can use to disactive this and allow me to select my own values from State B again? instead of " ='=sum({<Month=B::Month>}1)' "

Any suggestions would be much appreciated.

I've attached a simple QVW of all of this put together.

Thank you

topic Alternate States - Field Event Triggers in QlikView

Alternate States - Field Event Triggers