Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Filter pane with expression

Hi everyone,

I am trying to put this in filter pane, but it seems to have error, please help me:

if(GetFieldSelections(Period)='3 Mths',[Start Date] = {"$(='>=' & Date(today(2), 'D/M/YYYY') &'<=' & Date(AddMonths(today(2),3), 'D/M/YYYY'))"}

if(GetFieldSelections(Period)='6 Mths',[Start Date] = {"$(='>=' & Date(today(2), 'D/M/YYYY') &'<=' & Date(AddMonths(today(2),6), 'D/M/YYYY'))"}

if(GetFieldSelections(Period)='9 Mths',[Start Date] = {"$(='>=' & Date(today(2), 'D/M/YYYY') &'<=' & Date(AddMonths(today(2),9), 'D/M/YYYY'))"}

if(GetFieldSelections(Period)='1 Yr',[Start Date] = {"$(='>=' & Date(today(2), 'D/M/YYYY') &'<=' & Date(AddMonths(today(2),12), 'D/M/YYYY'))"}

if(GetFieldSelections(Period)='2 Yrs',[Start Date] = {"$(='>=' & Date(today(2), 'D/M/YYYY') &'<=' & Date(AddMonths(today(2),24), 'D/M/YYYY'))"}, [Start Date])))))