Using Variable in Set Analysis

[#1]

Hi

I'm trying to get this to work:

=Sum({<Year={vThisYear}>}[ActivityPlan])

Have tried juggling apostrophies, speech marks etc to no avail, can anyone help please?

Cheers

Geoff

[avinashelite]

Hi Geoff,

Please Try with this format

=Sum({<Year={$(vThisYear)}>}[ActivityPlan])

Regards,

@vi

[#3]

Hi Avi

Thanks but no joy. Have attached a screen show the nuts and bolts are in place.

Cheers

Geoff

[ThornOfCrowns]

As Avinash R says, you need to use Dollar Sign Expansion to push the actual value of the variable into your expression - it's a handy thing to remember.

[ThornOfCrowns]

You have varThisYear in the purple box and vThisYear in the blue one. Make sure you're using the right one in your expression and to put the dollar sign in place.

[avinashelite]

Hi Geoff,

Can you please provide me the sample app or data, so that i can work on.

Regards,

@vi

[#7]

Hi

I have tried this with all three expressions in a chart and get an empty table back. Hard coding '2014-15' works in the expression. I'd like to get this set so I don't have to go through all the expressions in n charts this time next year.

Cheers

Geoff

[#8]

Hi

Sorry typo in purple box. Expressions in app are vThisYear and are grey and itallic.

[sasikanth · Accepted solution]

hi

try some thing like below

=Sum({<Year={'$(=vThisYear)'}>}[ActivityPlan])

[#10]

Hi Sasikanth

Spot on  - adding the = before the variable has done the trick.

Many thanks

Geoff