Alternate State issues

[#1]

Hi,

another interesting issue... (for me 🙂 I'm a beginner)

Please see attached

See below for the Alternate states of the objects:

• Sheet:                Sheet2
• AAA:                  Inherited
• BBB:                  Inherited
• BS:                    StateG
• Left Date:          StateE
• Right Date:        StateF

For the left graph (AAA), I want to select a BS group (In
stateG) and a date (Left Date - StateE) and display the sum of the Amount on
the Graph (AAA).

And

For the right graph (AAA), I want to select a BS group (In
stateG) and a date (Right Date - StateF) and display the sum of the Amount on
the Graph (BBB).

Thus, I need to specify 2 alternate states in 1 expression.

Is this possible?

Thanks for the help...

[Gysbert_Wassenaar]

In general it's something like this: sum({<FieldA=State1::FieldA,FieldB=State2::FieldB>}Amount)

[#3]

This is what I get:

sum({<[ManAcc Definition]=StateG::[ManAcc Definition],[Fiscal Year]=StateE::[Fiscal Year]>} Amount)

But Qlikview does not except.

[#4 · Accepted solution]

The states does not turn blue when I type them in

regards

[#5]

Sorry,

I am stupid, this is perfect! I just needed to ad some spaces

Thanks