dynamic name alter state in set analisys

[warfollowmy_ver]

Hi, people!

For example

=sum( { ['Year_1_' & [Shop] ] } )

as

=sum({[Year_1_Shop1]} sales)

Year_1_Shop1 - it's name alter state

where shop it's field, and shop = shop1,

but shop2 will be =sum({[Year_1_Shop2]} sales)

How do it?

[Clever_Anjos]

You can use a dolar expansion

=sum({$(=Year_1_Shop' & anothervar)} sales)

[warfollowmy_ver]

task to glue the name of an alternate state, the dollar is only one choice. Have you checked? 😃

[Clever_Anjos]

Sorry, didn´t check it, but it works, please check attached

[Clever_Anjos]

The expression: =Sum({[$(='AE'&vEstate)]}Expression1)

[swuehl]

Do you expect your expression to consider the current chart dimension, i.e. Shop?

This won't work, since dollar sign expansion as well as set analysis is only evaluated once per chart, not per dimension line.

If this is the case, you would need to branch your expression based on dimension:

If(Shop = 'Shop1',

     sum({Year_1_Shop1} sales),

     If(Shop= 'Shop2',      sum({Year_1_Shop2} sales) )

)

Not sure if this comes close to what you are trying to do. Please detail your requirements and setting / context.

[Anonymous]

Hi warfollowmy_verysoon,

You can calculate it on variable, on Set Analysis call variable.

Variable -> ='Year_1_' & MinString([Shop])

Set Analysis -> =sum({$(YourVarName)} Sales)

Or you can do it with Variable with parameter

Variable -> ='Year_1_' &$1

Set Analysis -> =sum({$(YourVarName('Shop2'))} Sales)

Thanks,

[sunny_talwar]

Nice, good to see that it works

[warfollowmy_ver]

Thank you, but the problem is not the point. The task dynamically generate alternative state the name of the column name is not IF function. I have attached an example of your in my first post.

[warfollowmy_ver]

Thanks, but no need to IF. On if there is already 😃