QlikSense matching search criteria

[Rose1]

Hello, 

I am trying to use the select matching values in a field but it's not working  😞 

the idea is once you click on the button all the monthyear in the date dimension that are older than today should be selected . 

This is my formula :      ='=< Num(subfield(today(),'/',-1)&subfield(today(),'/',2))'

I am using Num() because my field's type on which I am filtering is Num and not date . 

FYI, I used ='=< 202001' to make sure it's working and it worked  .

any suggestions would be much appreciated . 

[Or · Accepted solution]

Try:

='<=$(=Year(Today())*100 + Month(Today()))'

Note that you can replace the year and month aspect with your subfields if you prefer, but this should give you the same outcome and I find it easier to read.