Set Selection field with Alternate States

[#1]

Hi,

When I click on some field on my straight table, for example "Name", I want the "Name" field with Alternate State called "StateA" will be filtered too - using  triggers. But I don't know the right syntax for this...

And I want to to the opposite case.

When I choose some value from the "Name" field on the Multi-Box with Alternate State "StateA" I want the same value on the Field "Name" without any  Alternate State will be seleceted.

Thanks in advance!

[tresesco]

Try to create a sample qvw and share

[CELAMBARASAN]

Could you explain the scenario that you are going to implement? There might be some other better way to do this.

[alexandros17]

If you need that an expression is influenced by set analysis, the syntax is

Sum({STATE1 <quarter={'Q1'}>} week)

where:

I used sum but you can use any aggregation function

STATE1 is the alternate state used in the list box (or multibox) to select values

quarter={'Q1'} is a condition (but you can omit it writing only: Sum({STATE1} week)

Let me know

[#5 · Accepted solution]

Thanks guys,

I found my solution.

When I define some new alternate state, the selection box with the wanted alternate state is shown near the text fields at the triggers window.

Thanks for your help!