topic Re: Title a column based on a selection in QlikView

Title a column based on a selection

Sat, 02 Nov 2013 13:51:30 GMT

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.

Re: Title a column based on a selection

swuehl — Sat, 02 Nov 2013 13:57:43 GMT

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.

Re: Title a column based on a selection

Anonymous — Sat, 02 Nov 2013 14:22:11 GMT

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

Re: Title a column based on a selection

Tue, 05 Nov 2013 21:18:45 GMT

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