Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

1 Solution

Accepted Solutions
MarcoWedel

You're welcome

please close this thread if there are no further questions

thanks

regards

Marco

View solution in original post

12 Replies
kuba_michalik
Partner - Specialist
Partner - Specialist

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.

Gysbert_Wassenaar

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
Author

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
Partner - Specialist
Partner - Specialist

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

MarcoWedel

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
Author

Worked perfectly! Thank you!

MarcoWedel

You're welcome

please close this thread if there are no further questions

thanks

regards

Marco

Not applicable
Author

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
Partner - Specialist
Partner - Specialist

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.