with button value for listbox exlude

[#1]

Dear QV-experts,

I have a simple problem:

I have a listbox with a lot of values. I can select multiple values for my report.

Now I want to have a possibility with button to include/exclude from the selected values follow value: 229.

How can I include one value to the selected values?

=GetFieldSelections(LE)& (LE=229) is not working

Kind regards,

André

[Kushal_Chawda · Accepted solution]

try this

='(' & Concat(DISTINCT{<LE-={'229'}>} chr(34) & LE & chr(34),'|') &')'

[sunny_talwar]

May be this needs to only work when something is already selected in LE:

If(GetSelectedCount(LE) > 0, '(' & Concat(DISTINCT{<LE-={'229'}>} chr(34) & LE & chr(34),'|') &')')

[erikzions]

use the action "Toggle Select" and just put the value 229. This will toggle it on or off.  Use only one button or text box and change the label for the current function of the button.

[#5]

thank you for your reply! It works

I have now two buttons: with/without "LE+/-={'229'}"

in one_button_solution

=if(Concat(DISTINCT(LE='229')),

'(' & Concat(DISTINCT{<LE-={'229'}>} chr(34) & LE & chr(34),'|') &')',

'(' & Concat(DISTINCT{<LE+={'229'}>} chr(34) & LE & chr(34),'|') &')'  

)