Dynamically changing label for comparative analysys

[#1]

Hi,

In Qlikview 11 there is a new feature called alternate state. I am using it to create some comparative analysis. Basically, I have two listboxes containing field 'Year' in different states. I was able to compare sales on a bar chart in different years by select them on the two listboxes. The two expressions I am using are

Label: =(Year)

Definition: Sum({state1}sales)

Label:=(Year)

Definition: Sum({state2}sales)

I would like to change the label when a different year is selected. For example. When I select 2011, 2011 should appear for the label. That's why I have made Label=(Year). However, I am only able to make it change in one state. Anyone knows how to make label change for both states?

Regards,

Xue Bin

[#2 · Accepted solution]

Can't you use Max({state2}year)?

[#3]

Hi,

It works:) Thanks. Any idea how to deal with the situation when more than one year are seleted?

Regards,

Xue Bin

[ashkrit501]

Try using getfieldselections(year) as the label