Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

mrudolphi
Contributor

create listbox with variable in expression

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?

1 Solution

Accepted Solutions
MVP
MVP

Re: create listbox with variable in expression

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.

5 Replies
MVP
MVP

Re: create listbox with variable in expression

How does the variable look like?

mrudolphi
Contributor

Re: create listbox with variable in expression

vUSNFDMParts='01012-US-G', '01012-US-S'

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

Not applicable

Re: create listbox with variable in expression

Hi,

    I think it's not possible

MVP
MVP

Re: create listbox with variable in expression

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.

mrudolphi
Contributor

Re: create listbox with variable in expression

That works.  Thanks

Community Browser