On Action button Select multiple value in Field

[swatitomar]

Hi All,

My Requirement is to select Year greater than equal to current fiscal year in Filter Pane. On Button Action , I need to Perform the activity. Can anyone help . 

Output: FY21, FY22,FY23

Year

FY19

FY20

FY21

FY22

FY23

[mato32188]

Hi @swatitomar ,

let's do it in steps. First create numeric representation of year field:

table:

load

Year,

num(20&right(FisYear,2)) as YearNum

from XXX;

Second, create temp table and variable for years to be selected in script editor

fis_year_selection:
load concat(distinct Year,';') as FisYear_Selection
Resident tmp
where YearNum>=Year(Today());

let vFiscalYearsSelection = Peek('FisYear_Selection',0,'fis_year_selection');

drop table fis_year_selection;

Third, create button object with following settings

BR

m