Using variable for Field value(Column) in Set Analysis

[satishsure]

I have variable called $vYearTotal. and I need to use in set expression to fetch for previous year.

=sum( {1<Year = {2015}>} $(vYearTotal) ).

I am trying to create new column using the above set expression.Not working for me.

[sunny_talwar]

How do you define vYearTotal?

[satishsure]

Getting from another expression below
Num(

Sum( {$< Flag={1}, Year=, Quarter=, Month=, [Quarter In Year]=, [Month In Quarter]=>} $(vSelectField)

) / [Div],

Pick(WildMatch([Div], 1, 1000, 1000000), '#,##0', '#,##0', '#,##0.0')

)

[sunny_talwar]

You can try this

=Sum({1<Year = {2015}>} Aggr( $(vYearTotal), YourChartDimension))

[satishsure]

Sunny..I don't have chart expression. As I need to create new Column $(vYearTotal) which should get results of previous year irrespective of selection.

=Sum({1<Year = {2015}>} Aggr( $(vYearTotal), YourChartDimension))

[satishsure]

Sunny I have tried adding Aggr on Variable but no luck.Can some body suggest me.

[satishsure]

Sunny..I have attached the qvw and Expression column is "Selection" in the Main straight table

[sunny_talwar]

What is this qvw showing my friend? I am not sure where is the variable vYearTotal

[satishsure]

It is a front end variable

[sunny_talwar]

Is this not the requirement?

Sum({<Year = {2015}>}Aggr($(vYearTotal), Year))