Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternate State

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

1 Reply
agilos_mla
Partner - Creator III
Partner - Creator III

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