topic Re: Alternate states issue in QlikView

Alternate states issue

Tue, 23 Jul 2013 12:32:47 GMT

Good day,

I am busy with a alternate state solution: (Please see attached)

See below for the Alternate states of the objects:

The issue is, I need the legend description to change when I select different BS groups (in AAA and BBB).

e.g. when I select "Nett Income" from AAA, the legend description for the blue line must read " Nett Income " but

AAA is in "StateA", not the default state like the graph, so I need to use {StateA} in the expression.

This is what I wanted to use:

=GetFieldSelections ({StateA} [ManAcc Definition])

but this is not allowed.

Is there any other way?

Please help...

Gysbert_Wassenaar — Tue, 23 Jul 2013 12:36:09 GMT

Perhaps =only({StateA} [ManAcc Definition]). If not please post an example qlikview document. Preparing examples for Upload - Reduction and Data Scrambling

Tue, 23 Jul 2013 12:42:30 GMT

=Only({[ProduktSammenligning1]} ProductName)

=Only({[alterNatestate]} Dimensionname)

Do like this

Tue, 23 Jul 2013 12:43:33 GMT

It worked!

Thanks