Alternate State

[#1]

Hi Folks,

I am having  challenges in getting alternate state to work with the below expression

Kindly could someone guide me in the right direction.

My Expression

sum(if(Nyear=MainYear,{state1} sales))

regards

Varghese

[agilos_mla]

Hi,

In document proerties/general , create a alternate state. In the object properties/General select the state

Assuming Main Year is in the default state $, you should have sthg like this

sum({state1 <Nyear = $::MainYear> sales}

Refer to this good document  from F.Aunez : http://community.qlik.com/docs/DOC-4951

Hope this helps,

Michael