Solved: create listbox with variable in expression - Qlik Community

Anonymous · ‎2015-09-25

I would like to create a list box using a variable in the expression. The variable contains the names I want displayed for selection in the list box.

Is this possible?

swuehl · ‎2015-09-26

You can try using the variable as filter, use something like this as <expression> list box field (replace FieldToFilter with the field name):

=If(Match(FieldToFilter, $(vUSNFDMParts) ), FieldToFilter)

Just like a calculated dimension.

swuehl · ‎2015-09-25

How does the variable look like?

Anonymous · ‎2015-09-25

vUSNFDMParts

=

'01012-US-G', '01012-US-S'

The items within the ' ' are names within a field.

Report Inappropriate Content · ‎2015-09-26

Hi,

I think it's not possible

swuehl · ‎2015-09-26

You can try using the variable as filter, use something like this as <expression> list box field (replace FieldToFilter with the field name):

=If(Match(FieldToFilter, $(vUSNFDMParts) ), FieldToFilter)

Just like a calculated dimension.

Anonymous · ‎2015-09-26

That works. Thanks

create listbox with variable in expression