Title a column based on a selection

[#1]

Hi,

I'm using a number of set analysis expressions to generate some columns in a table. The displayed data is selected in list boxes all linked to alternate states.

My question is simply, how can I drive the labels of the columns to be the same as the selection made in the list box for that particular set of data?

I hope my explanation is OK. I've only been working with Qlikview for a short time.

Thanks,

Torsten.

[swuehl]

Maybe use a label expression like

=only({ALTERNATESTATE} FIELD)

replace ALTERNATESTATE with the alternate state name and FIELD with the list box field name.

You can concatenate several of these functions to create more complex expression labels.

[Anonymous]

Torsten

The suggestion of swuehl will work fine if you only select one value for the field, if multiple values are selected then you will need something like:

     =concat({[ALTERNATESTATE]} distinct [FIELD],', ')

Best Regards,     Bill

[#4]

Thank you both for the reply. I have tried this and it works perfectly! I just thought I'd reply so others know it's all good