Dynamic year selector - SAS VA

[sid5005]

Hi All,

On selection of year from dropdown the list table should display selected year as well as previous year. But right now it shows only data for the selected year not the previous year. I have used aggregated measures to calculate previous year GP and Variance between current and previous year. I have created these measures using periodic functions. The data type of the Year in the dropdown is date.

PFA the screenshots

Thanks for the hel

[Sam_SAS · Accepted solution]

Hello,

If you look at the expression for your aggregated measures, you might see an parameter on the periodic operator that says "_ApplyAllFilters_". (I believe this was added in the 7.4 release.)

If you change that parameter to "_IgnoreAllTimeFrameFilters_" or "_IgnoreInteractiveTimeFrameFilters_", your list table should the previous years' values as desired.

If you have an earlier VA release, then you might be able to work around the issue by pre-calculating the values in your data query.

Thanks,

Sam

[sid5005]

Thanks SAS_SAM the solution suggested by you worked perfectly.

[Sam_SAS]

Great! Thanks for following up with us 🙂