Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danielco223
New Contributor III

Rename a field in a dimension

I need to change the name of a filed in a dimension within the data table. We have a list of user names associated with orders, but one user name is a person that is always associated with automated orders, so his name being in the list is inaccurate. For the dimension "Order - Created By Header", I want the name "Glazer, George" to be displayed as "Automated User" while all the other fields stay as they are. For example, below is the current way the data is displayed

 

Order - Created By Header
Glazer, George
Jones, Amy
Smith, Mike

But I want it to load this way

Order - Created By Header
Automated User
Jones, Amy
Smith, Mike

Thanks!

4 Replies
rittermd
Honored Contributor

Re: Rename a field in a dimension

I think if you created an expression something like this,

If (username='Glazer, George','Automated User',username)

rittermd
Honored Contributor

Re: Rename a field in a dimension

Or you could put something similar in your load script so that it is changed up front and then you can just display the field as your Dimension without any expression.

danielco223
New Contributor III

Re: Rename a field in a dimension

Thanks! How would that look in the load script?

rittermd
Honored Contributor

Re: Rename a field in a dimension

You could pretty much use the same logic but add an AS at the end and give the new field a name.  Then use that field name as your Dimension in your app.