Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Updating field names

I am trying to update the field names listed within my 'List Box' - the field names are pulling from a table loaded into our script. But I would like to overwrite the field names with an alias. Is this possible, without updating the source table? Can this be achieved by creating an Expression within the list box?

Tags (1)
1 Solution

Accepted Solutions

Re: Updating field names

You're welcome

please close this thread if there are no further questions

thanks

regards

Marco

12 Replies
kuba_michalik
Contributor III

Re: Updating field names

Do you mean field names that you see in a dropdown when you create a new listbox and have to choose which field is it going to show? If so, then you can not change those names in any way other than aliasing or renaming them in the datamodel. You don't have to change them in the source itself, just in the loadscript. One expedient way of doing that is through the "RENAME Using" statement.

Re: Updating field names

I'm not quite sure what you want to do, but perhaps this blog post can help you: Handling Multiple Languages. It sounds like scenario 2 from the blog post is what you're interested in.


talk is cheap, supply exceeds demand
Not applicable

Re: Updating field names

Thank you for your response. Can you help me build the script required? I am not familiar with the "RENAME Using" statement

List Box Details:

Filter Name = Program Name

Current Filter Fields = Bank 1, Bank 2 and Bank 3

Want to change to:

Filter Name = Program Name

Filter Fields = Program 1, Program 2, and Program 3

kuba_michalik
Contributor III

Re: Updating field names

I'm not fully clear on how it looks now. Could you post a screenshot?

Re: Re: Updating field names

Hi Gretchen,

I guess you are trying to replace/alias field values instead of field names, so one solution could be:

QlikCommunity_Thread_139007_Pic1_.JPG.jpg

QlikCommunity_Thread_139007_Pic2.JPG.jpg

=Pick(Match([Program Name],'Bank 1','Bank 2','Bank 3'),'Program 1', 'Program 2', 'Program 3')

LOAD * INLINE [

    Program Name

    Bank 1

    Bank 2

    Bank 3

];

hope this helps

regards

Marco

Not applicable

Re: Re: Updating field names

Worked perfectly! Thank you!

Re: Updating field names

You're welcome

please close this thread if there are no further questions

thanks

regards

Marco

Not applicable

Re: Re: Updating field names

Hello,

As mentioned previously, I was able to successfully update the field names within my List Box but the field names are not flowing through to our Selection Box - is it possible to update the field names that appear there as well?

kuba_michalik
Contributor III

Re: Re: Re: Updating field names

That's because you've changed only what is shown in one particular listbox without touching the underlying data. If you want to change it permanently, you will need to do it in the loadscript. One possible way is this:

LOAD Pick(Match([Program Name],'Bank 1','Bank 2','Bank 3'),'Program 1', 'Program 2', 'Program 3') as [Program Name]

;

LOAD * INLINE [

    Program Name

    Bank 1

    Bank 2

    Bank 3

];

and then just use [Program Name] for the listbox.

If you have many values to change like that, a mapping table would be much better than Pick+Match.

Community Browser