topic Re: Dynamic year selector - SAS VA in SAS Visual Analytics

Dynamic year selector - SAS VA

sid5005 — Tue, 17 Sep 2019 12:29:13 GMT

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

Re: Dynamic year selector - SAS VA

Sam_SAS — Tue, 17 Sep 2019 13:29:23 GMT

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

Re: Dynamic year selector - SAS VA

sid5005 — Wed, 18 Sep 2019 06:39:14 GMT

Thanks SAS_SAM the solution suggested by you worked perfectly.

Re: Dynamic year selector - SAS VA

Sam_SAS — Wed, 18 Sep 2019 12:38:15 GMT

Great! Thanks for following up with us 🙂