topic Alternate State issues in QlikView

Alternate State issues

Tue, 23 Jul 2013 13:48:09 GMT

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...

Re: Alternate State issues

Gysbert_Wassenaar — Tue, 23 Jul 2013 13:53:34 GMT

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

Re: Alternate State issues

Tue, 23 Jul 2013 14:07:41 GMT

This is what I get:

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

But Qlikview does not except.

Re: Alternate State issues

Tue, 23 Jul 2013 14:31:05 GMT

The states does not turn blue when I type them in

regards

Re: Alternate State issues

Wed, 24 Jul 2013 07:37:14 GMT

Sorry,

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

Thanks