Dynamic Default selections Qlik Sense

[Ilya_K]

Hi to all.

I need to set  Default select for Year  Month filter taking the value 3 completed months back from today.

My Year Month filter values are like this: Nov 2021, Oct 2021, Sep 2021, etc ...

I create a function  Month(MonthEnd(TODAY(),-3))&' '&Year(MonthEnd(TODAY(),-3))

the result are  Nov 2021

And I tried to tape it YearMonth=Month(MonthEnd(TODAY(),-3))&' '&Year(MonthEnd(TODAY(),-3))

or  YearMonth=(Month(MonthEnd(TODAY(),-3))&' '&Year(MonthEnd(TODAY(),-3)))

or YearMonth='Month(MonthEnd(TODAY(),-3))&' '&Year(MonthEnd(TODAY(),-3))'

or YearMonth=TEXT(Month(MonthEnd(TODAY(),-3))&' '&Year(MonthEnd(TODAY(),-3)))

None of this are  working for me, the filter didn't catch the value .

Thanks in advance for your help.

[anat]

May be format issue, try to convert to number format using num function