Dynamic Default selections Qlik Sense

Ilya_K — Sun, 06 Feb 2022 14:58:29 GMT

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.

Re: Dynamic Default selections Qlik Sense

anat — Sun, 06 Feb 2022 21:49:13 GMT

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