Proper Format for Sheet Action Expression

[Ericga]

I cannot get expressions to work in Sheet or Button Actions.  i would like to use an expression to select values over a specific number such as =FieldName>5  when a sheet opens but nothing happens.  Same with the button.  i can type >5 in the search on the filter pane and it works and i can create a  bookmark that works.  This article https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Sheets/setting-sheet-acti... says it needs to be in single quotes but that doesn't work either.  i can put static values in the expression list and it works when the sheet opens but expressions as i know them are not working. 

This is the same behavior in both Qlik Sense Enterprise and Qlik Cloud

I have attached a qvf with the Actions in the Buttons showing what i am trying to accomplish

What am i doing wrong? Thanks

[Digvijay_Singh · Accepted solution]

Try like this - 

[Ericga]

Ahh ok. Thank You.  So using the action of  "Select values matching search criteria" is key here.  I was trying to equate the Select values in a field to the Select In Field in QlikView.  Now, if i can just get the Date expression to work!

[Ericga]

Date Expression worked also! I used  ='=CloseDate>monthstart(addmonths(today(),-12))' and it worked as expected. 

Thanks again Digvijay_Singh