Set analysis in dimmension?

[#1]

Hi in the app i have Year.

You can select only one year, and you must always have 1 year selected

In a table i wanna have all the years in the dimmension

what should i do?

Thank you

Greetings.

[ToniKautto · Accepted solution]

Set expressions should be used in expressions. The dimension will expand based on the set expression you apply in the expression.

For example this set expression will deselect the year in your calculation...

=sum( {<Year=>} MyField)

[#3]

How can i do a set expression if i have the value in a variable?

[ToniKautto]

What value are you referring to?

You mean like this?

=sum( {<Year={"$(vMyVariable)"}>} MyField)

Notice that the variable will not actually vary within the chart, instead it will be expanded prior to the expression being evaluated.

Set expression and dollar expansion