Alternate State

Sun, 12 Oct 2014 19:31:15 GMT

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

Re: Alternate State

agilos_mla — Sun, 12 Oct 2014 19:59:59 GMT

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