Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
select the items you dont want in list
then select Excluded
and again select exclude to see excluded values
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.
can you please come again with clear requirement?
Thank you Aaron,
Finally I used MaxString({1-$}[Field name]), Count() also works.
Auke
This is nice.
You can also use it to create a list.
vList =Concat({1-$}[Field name], ',')
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?
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.