How to show only the excluded values in a List box

[#1]

Hello,

Is it possible to show only the excluded values in a List box.

There is an option 'Hide Excluded', but in this case I just want the opposite (only show excluded).

Auke

[SunilChauhan]

select the items you dont want in list

then select Excluded

and  again select exclude to see excluded values

[#3]

I am creating a dynamic filter/searchstring like: = Field1 like '*ab*' or Field2 like '*xx*'

The result of this is shown in a Table box.

The List box is for reference to see if I have to extent the filter/searchstring.

[SunilChauhan]

can you please come again with clear requirement?

[Anonymous · Accepted solution]

How about creating a straight table with your field name as the dimension and something like this as the expression: =MAXSTRING({1-$<[Field Name]={'*'}>} [Field Name]) .  Then set the expression to be hidden in the presentation tab.

[#6]

Thank you Aaron,

Finally I used MaxString({1-$}[Field name]), Count() also works.

Auke

[#7]

This is nice.

You can also use it to create a list.

  vList =Concat({1-$}[Field name], ',')

[udaya_kumar]

Hi Aaron,

even i need the same thing, i need to show only the excluded values in the listbox.

if i use straight table instead of listbox, it works fine, but the values also should be selected after adding that.

like in listbox, we can select any values (multiple values) and filter data based on that.

but i put straight table, then i cannot select the desired values from that right.

we need to select only the consecutive values.

so how we can solve this issue?

can anyone help me?

[#9]

Hi,

If your requirement is to show only not associated values in the listbox.

Try this.

1. Go to the properties of the listbox

2. Go to the General tab -> Field -> Expression

3. Give this code over there    =aggr(Only({1-$} FieldName),FieldName).

Then the listbox will show all not associated values.

I welcome all your feedback.