topic Re: with button value for listbox exlude in QlikView

with button value for listbox exlude

Wed, 08 Jun 2016 13:58:35 GMT

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é

Re: with button value for listbox exlude

Kushal_Chawda — Wed, 08 Jun 2016 15:23:15 GMT

try this

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

Re: with button value for listbox exlude

sunny_talwar — Wed, 08 Jun 2016 15:50:07 GMT

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),'|') &')')

Re: with button value for listbox exlude

erikzions — Wed, 08 Jun 2016 15:58:30 GMT

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.

Re: with button value for listbox exlude

Fri, 10 Jun 2016 12:33:49 GMT

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),'|') &')'

)