Expression to ignore one filter and select another with button selection

[richard24best]

Hi Team,

I have created a button where it will filter only Rubix values

Got Year and Date filter - When user selects Year no changes required, but when user selects Date need the values to change

Currently using the below expression where Rubix filter and year selection is working not sure how to implement Date selection changes (Activity Date)

if($(vRubixName)=1,
(Count({1<Activity_Date= {$(vMaxDate)},Status_Business = {'Remediated'},Yearly_Automation_New=>}
if(Remediated_Flag<>'Y' and Yearly_Automation_New >= Year(today()) ,[Process Reference]))),
(Count({<Activity_Date= {$(vMaxDate)},Status_Business = {'Remediated'},Yearly_Automation_New=>}
if(Remediated_Flag<>'Y' and Yearly_Automation_New >= Year(today()) ,[Process Reference]))))

Appreciate your help in advance.

Regards,

Richard

[rubenmarin]

Hi, can you give more details on what you have, what you get and what you want? what should change and no changes?