topic Change fields name in Current Selection Box in QlikView

Change fields name in Current Selection Box

jaymerry — Fri, 18 Mar 2011 08:59:17 GMT

Hello all,

Do you know if it's possible to change the fields name in a Current Selection Box.

I would like to replace some ID (which correspond to my current selection) by an explicit field name for a better user understanding.

Thank you for your help,

Regards,

Jaymerry

Change fields name in Current Selection Box

Miguel_Angel_Baeyens — Fri, 18 Mar 2011 09:11:45 GMT

Hello Jaymerry,

There is not, since the Current Selection object just shows the relation between fields and values selected in them. So you will have to change their names in the script.

Another option is that you know what fields are being used (say for example, customer code and customer name) and you create several Multi Boxes having the description fields, instead of the code, and so show the values the user has selected in Customer Code, but displayed as Customer Name.

Hope that helps.

Change fields name in Current Selection Box

jaymerry — Fri, 18 Mar 2011 15:18:18 GMT

Hello Miguel, thanks for your answer.

As some of my fields (no necessarily ID fields) are renammed dircectly in the dashboard objects (field or dimension label), I need to modify dircetly in my Load script.

Regards,

Jaymerry

Change fields name in Current Selection Box

Miguel_Angel_Baeyens — Fri, 18 Mar 2011 16:32:07 GMT

Hello Jaymerry,

I'm used (I figure that so many of the other developers are) to use codes for anything, specially to associate tables and set analysis. But I always create as well fields with "code - description" for anything that requires it, item references, customer or vendor names, countries or cities, etc.

Regards.

Change fields name in Current Selection Box

jaymerry — Fri, 18 Mar 2011 17:34:29 GMT

Hello Miguel,

That's exactly what I have done. But sometimes, after users feedback, I have renamed directly some fields into the dashboard object.

But now, they see something different between the current selection box (which contained the real name of the field) and the dashboard object.

Never mind, I will modify directly their name into my script.

But thanks for your advice.

Regards,

Jaymerry