Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
SUM({<Year = {'$(=Max(Year)-1)'}>}YourField)
SUM({<Year = {'$(=Max(Year)-1)'}>}YourField)
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 '-'
Not sure what is $(vFXImpactvsPY)
You have to provide sample data / sample app to work.
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