Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
chrweber
Creator
Creator

Show Formula Values of non-selected Listbox items (like only)

I want to replicate a table that allows multi-selection using a listbox.

I use formulas to and show the non-selected values.

I use only({1}, <Field>) to show the values of the fields of the non-selected items.

But this only works for fields with a single value (So I understand from the definition of only)

My question: Is there a function that allows me to simply show the values using the {1} set expression without any side effect.

Something like:

ShowValues({1}, <Field>)

?

Best Regards

6 Replies
marcus_sommer

It's not quite clear for me what do you want to do. Therefore it would be helpful if you provides some fieldvalues from one or several fields and how they should be displayed.

- Marcus

chrweber
Creator
Creator
Author

Hi Marcus,

I am wondering if there might be a case where a formula / column entry might contain more than one field value.

In that case the only function would not return the content.

-Christoph

marcus_sommer

You mean a fieldvalue looked like?

Value1 AnyDelimiter Value2

- Marcus

chrweber
Creator
Creator
Author

I do not know how this would be displayed or how only() parses its input, but probably yes

marcus_sommer

Please provide something which displayed which input of data should result in which output.

- Marcus

chrweber
Creator
Creator
Author

I will, once I encounter the actual problem.

Until then it is postponed. thank you.