If you are talking about default selection, you are talking about setting these values on opening the document or when you enter a sheet, something like that?
You can use actions triggered by some event to achieve what I think you want.
For example, create a button with action Selection - Select in Field.
Then enter
Year
as field name, or however your Year fieldname is (but without equal sign or single quotes, just the name)
and as search expression:
='=sum({<Years = {">$(=max(Years)-2)"}>} 1)'
A click on the button should select last two years, please see attached demo.
If this works, you can use any appropriately triggered action e.g. under document properties -Triggers - OnOpen event, to have this done automatically.
If you are talking about default selection, you are talking about setting these values on opening the document or when you enter a sheet, something like that?
You can use actions triggered by some event to achieve what I think you want.
For example, create a button with action Selection - Select in Field.
Then enter
Year
as field name, or however your Year fieldname is (but without equal sign or single quotes, just the name)
and as search expression:
='=sum({<Years = {">$(=max(Years)-2)"}>} 1)'
A click on the button should select last two years, please see attached demo.
If this works, you can use any appropriately triggered action e.g. under document properties -Triggers - OnOpen event, to have this done automatically.
you need to look out for the second single quote at the very end, it's a string, like
='AdvancedSearchExpressionString'
where the advanced search expression is
=sum(....)
Don't ask me why we need to enclose an advanced search expression in single quotes with a preceding equal sign when used in a selection action. IMHO search expressions are probably the worst documented part of QV I know of.
