topic Friendly field names in current selections in QlikView

Friendly field names in current selections

Tue, 20 Jul 2010 18:53:54 GMT

Would like to use the current selections object, but want to have friendly field names for the users to see. See attached screen shot. I have a multi box with several fields including "RollupWeekDay" which I have a label of "Day of Week" defined. In the current selections object I would like to also use the field label of "Day of Week".

Friendly field names in current selections

Tue, 20 Jul 2010 19:31:00 GMT

Jims,

The easiest way to accomplish this is to change the field name in the load script:


LOAD:
RollupWeekDay AS "Day of Week"

Let us know if this does the trick.

Friendly field names in current selections

Tue, 20 Jul 2010 20:56:19 GMT

I may not be able to change the name of the field using the load option because of some other internal requirements.

Is there any way to use one of the UI objects to create something that could list the current selections with a friendly user name?

Friendly field names in current selections

Wed, 21 Jul 2010 08:25:47 GMT

I have the same requirement, I have field names that are identified specifically to make development easier (they have prefix characters for identification) so I cannot change field names, but would like to use labels in the current selections. It is not possible to do this in any version up to & including V9 SR5.

It's possible that this may change with Version 10 when more emphasis has been placed on metadata, maybe this version will allow you to set up labels for fields in one place which would make more sense. At the moment we have to label a field in every area we use it, I'm assuming from Jason's response that QlikTech simply assume that fields will be named appropriately on load, but in our case this won't happen and for very good reasons.

Friendly field names in current selections

Wed, 21 Jul 2010 10:15:24 GMT

Could you use 'Alias' in the script so that you dont need to worry about renaming the fields in the LOADs?

Gordon

Friendly field names in current selections

Wed, 21 Jul 2010 11:18:32 GMT

Hi Gordon

I don't think (think being the operative word, I can't be sure) that the alias will work for me, the main reason for using prefixed field names are for development of objects, we have hundreds of fields in our applications so when we develop new objects it's easier to find the relevant fields we need for that object because they are in the correct order in the list according to the prefix.

Looking at the alias function, it looks as though it does do a rename at some point.

I think what I'm looking for is for me to be able to globally set a label for each field, and that I can use that label in all objects.

Regards,

Friendly field names in current selections

Wed, 21 Jul 2010 19:38:29 GMT

Agree with Nigel.. need a label for certain fields just like you can do in charts with dimensions and expressions. Need to show current selections that match the name we have used in the dimension or expression.

Friendly field names in current selections

tduarte — Wed, 09 Feb 2011 17:13:42 GMT

Hi all,

I've been renaming the fields in the script so far but as Gordon said before that will spoil your field name convention.

The option to have a global label for a given field would do the trick.

Has anyone got any new ideas regarding this? QV10 maybe?

Regards,

Telmo