Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Values from two fields in same listbox?

Is there anyway I can use an expression or something to put the values of two different fields in the same list box?

4 Replies
Not applicable

Re: Values from two fields in same listbox?

=field1 & field2

Not applicable

Re: Values from two fields in same listbox?

Sorry, forgot the caveat of from two different tables.

Not applicable

Re: Values from two fields in same listbox?

ok, could you precise me if you need to do that in the script or directly in the list? (In the list, it's working)

Not applicable

Re: Values from two fields in same listbox?

Create a list box and in the properties, instead of choosing a field name, choose <expression>. Then, in the expression dialog box, try this:    =FIELD1 & ' - ' & FIELD2              then click OK. You will then have a list box that shows all of the combinations of the two field values that occur in the data separated by a hyphen (you can format that any way you like). A single click on the values shown in the list box selects the corresponding value from each of the two fields at once. 

Community Browser