how to change field name in current selection box?

[jim_chan]

Hi guys,

I have a problem. i have the current selection box. For instance, i have a dimension called project_one.

i managed to change that to a proper name in a listbox, as i could name a new label.

however, in current selection box, it shows project_one instead of showing the label name i have set?

how can i change it in current selection box?

Rgds,

Jim

[#2]

I am not sure whether this can be achieved with current version, but there are lot of request for this feature.  In the meantime also have a look at the "Better current selection" object extension if that is helpful in your situation.

Better Current Selections Box to Translate & Hide Fields (QlikTip #49)

[tamilarasu]

Jim,

Someone discussed the same topic on below thread.

Renaming fields in "Current Selections"

[ecolomer]

Try this:

=Replace(GetCurrentSelections(), 'FIELDNAME_IN_SCRIPT', 'Field')

[avinashelite]

As per my knowledge you cannot change the field name in the current selection box it appears as the field name in the script. In order to show different filed name you need to change the name in the script ...or build your own current selection box using a text box ..so that you can add your own expression and rename the fields

Hope this helps you

[er_mohit]

Hi jim.chan,

The best way is to rename the field at backend level.  that would be helpful for you also to recognise the exact fieldname name as you want in front end level.

However, once you built your data model. and after that use function rename field which could be eaiser for you to rename the field which present in any table of data model.

Like you have field in data model employe_id and you want to change it with Employee Code. For this do in script

Rename Field employe_id  to [Employe Code].

Regards

Mohit

[marcus_sommer]

Recommended is to create user-friendly fieldnames within the script to avoid such trouble with the current selection box and also to label every listbox-caption or dimension-label different.

But of course there are possibilities to adjust the current selection box, see:

Current Selection Alternatives

"Better Current Selections Box" with support to hide/translate fields

- Marcus

[#8]

But this will not give the feature that Current Selection box has, like clearing up selective filters etc..

[jim_chan]

i have thought of that as well. currently, i have already built the entire data model. If i used the employe_id as an example, the current employe_id has already been used as link key to some other tables.

if is to change, i assume is gonna change my data model as well.

. Will other alternative like mapping file work on this as well?

RGds

jim

[marcus_sommer]

You could simply double this field with a user-friendly name within the appropriate dimension-table and use then this field within the gui especially as it is recommended not to use key-fields within the gui.

- Marcus