LIST BOX - If none selected, select all

[avantime]

Hi

In the attached app I am loading 5 items, A, B, C, D, E.

In a listbox I am showing only A B C D, without E. I am also preselecting these 4 values.

The problem is that after I select one or more items in the listbox, once I clear the selection E is also selected by default.

How can I force the listbox to select ABCD by default?

Hope I made myself understood .

[sunny_talwar]

When you clear E is also selected? How can you select when you press clear? I am not sure how you are clearing? Can you explain?

[surendraj]

Select 4 at a time...(A,B,C,D)

enable-->set clear state--->save-->colse the app.

By your on open trigger it will defaultly show 4 selected values.

now even you clear selections, that are not cleared till you press reset clear state.

[avantime]

Check attached,

When I click "Clear selections" I want need the total value to be 10 (Select only ABCD).

[sunny_talwar]

Then use set analysis to exclude it?

Sum({<ITEM -= {'E'}>}VALUE)

or

Sum({<ITEM = -{'E'}>}VALUE)

[tresesco · Accepted solution]

May be like attached sample.

[avantime]

Yes, exactly like that

Can you please explain what you did?

[avantime]

I know how to exclude E from Sum, this is not what I need. I need to apply this selection over tens of formulas.

[sunny_talwar]

Very smart tresesco

He added a trigger to OnAnySelect

[avantime]

Works like a charm. Thank you!