Field name in Current selection

[arusanah]

Hi

I'm using a %KEY_PAYER field to create my dimension. so when iIam selecting value from this object , my current selection box shows %KEY_PAYER      ' AbC' . my requirement is that user should See "Payer "  instead of %KEY_PAYER in current selection box .

how can we do that ?

[ramoncova06]

changing your %KEY_PAYER to Payer  in the loading script

if you want to keep %KEY_PAYER because is a key, then create a second column with it's information and call it Payer 

[arusanah]

I was thinking abt the same but then isnt it gonna add to duplicate value in ur Data model .

[jaimeaguilar]

Hi,

you may keep the %KEY_PAYER field in case it is a key and also if you want to be consistent in naming your fields. However, if you want that user sees "Payer" as the name of the field (either in current selections box or any other object), you can create a duplicate of your original field. This way the %KEY_PAYER field can be kept as a key field and the new "Payer" field can be used in front-end,

regads

[ramoncova06]

it will, but I doubt it will have any performance impact, unless you have millions of distinct payers, in that case it probably better to add an autonumber to your %key fields

this post from HIC helps The QlikView Cache‌explain why is not an issue