Help with Set analysis ! Help !

[Anonymous]

Please see attached qvw. Unable to attach app : too big

I have columns 2016, 2017 on table

Right now column 2016 shows 2016 values  and 2017 shows 2017 values.

What is the expression so then user selects 2017 - only shows values from 2016 ?

Prior year

This is the expression :num( ($(vFXImpactvsPY)) *(vDivider),MoneyFormat)  in table for column 2017

This is the expression : num( ($(vFXImpactvsPY2)) *(vDivider),MoneyFormat) in table for column 2016

[MK_QSL · Accepted solution]

SUM({<Year = {'$(=Max(Year)-1)'}>}YourField)

[Anonymous]

Here is the problem - the 2017 - half of are zero values.

Do you need 2 complete sets of data to perform set analysis ?

Due to the  dimension being an expression being a variable inside a variable in this case : $(vFXImpactvsPY)

$(vFXImpactvsPY)  is not being recognized as a dimension.   Returns 0  or '-'

[MK_QSL]

Not sure what is $(vFXImpactvsPY)

You have to provide sample data / sample app to work.

[Anonymous]

It's too big to load.

What do you think of using the Only ()

Since 2 of those expressions are the same I can use the second on to fill 2017 column with 2016 values.

The problem is since 2017 - is all zero from Apr - Dec

When I use that expression it does not return prior year value from Apr -Dec