Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Making selections in a multibox via a formula match()+concat()

Hi,

i  want to be able to make a selection via a formula in a multibox.

I know this is possible, as I have seen this be used through triggers before.

Furtermore, copying the text the string generates into the multibox also does the trick.

Copying the formula itself however does not work. I have tried to play around with " ' " but have been without succes up to now.

I think I am very close...?

='=match('&'warehouse_1'&chr(44)&chr(39) &concat({1<warehouse_1={'01','14'}>} warehouse_1,chr(39)&chr(44)&chr(39))&chr(39)&chr(41)

0 Replies