topic Re: Field name in Current selection in QlikView

Field name in Current selection

arusanah — Tue, 21 Apr 2015 21:09:00 GMT

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 ?

Re: Field name in Current selection

ramoncova06 — Tue, 21 Apr 2015 21:23:18 GMT

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

Re: Field name in Current selection

arusanah — Tue, 21 Apr 2015 21:45:57 GMT

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

Re: Field name in Current selection

jaimeaguilar — Tue, 21 Apr 2015 21:47:13 GMT

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

Re: Field name in Current selection

ramoncova06 — Tue, 21 Apr 2015 21:59:25 GMT

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