range selection

[warrentk80]

Hello to all

I need to make sure that if the user selects a month (eg May)

Automatic selection range to take the January, May.

is it possible?

thanks

Andrea

[MK_QSL]

Go to Document Properties

Trigger

Field Event Trigger

Select Your Month Field

Add Action

Add - Select In Field

Field

Month

Search String

='('&concat({1<Month={'<=$(=Max(Month))'}>} aggr(only({1<Month=>}Month),Month),'|',Month)&')'

Now Create a List Box for Month Field and Select any month...

[shawn-qv]

In your example, if a user selects May in Month, do the other months (i.e. Jan - Apr) need to be shown as selected (i.e. highlighted in the QV "green")?

Or do you only require the values (i.e. a date range) as a criteria in your calculation?

S.

[warrentk80]

initially I wanted to use the selected months in the expression, then since I have not solved the problem I changed the street and thought I select in the green range.

thank you

Andrea

[warrentk80]

ello, Thank you for having responded to me,

I performed the instructions you sent me.

and inserted into the search field on the month 'action

= '(' & concat ({1 <Month = {'<= $ (= Max (Month))'}>} aggr (only ({1} <Mese=> Month), Month), '|', Month) & ')'

then I created a list with the month field but if I select a month, it's business as usual.

thank you

Andrea

[MK_QSL]

Can you attach your sample file?

[MK_QSL · Accepted solution]

CHECK ENCLOSED FILE...

[warrentk80]

Great, just what I was looking for 🙂

Thank you very much

Andrea

[warrentk80]

Hello, another question if I may.

the selection of the month I cancel all selections, on other fields, how can I avoid this?

thank you

Andrea

[MK_QSL]

Not getting your question properly... can you please elaborate little more?