topic SV:question about alias in QV in QlikView

question about alias in QV

Thu, 14 Apr 2011 02:42:13 GMT

Hi,

I have a mutibox in qvw file. And there is a field named [dept]. I select "fields displayed in mutibox" and type label as "department" in "settings in selected field". It works well. But when I click the field, the current select box show "dept: sales".

My question is how to show 'department:sales ' in current select box instead of change the field name when ETL.

Thanks.

question about alias in QV

Miguel_Angel_Baeyens — Thu, 14 Apr 2011 04:41:03 GMT

Hello,

You will have to rename fields in the load script,

Table:LOAD Dept AS Department,...

Besides, you can later label the listbox (not the field) to display in its caption something different.

Hope that helps.

question about alias in QV

Thu, 14 Apr 2011 06:40:38 GMT

Hi,

I know I can rename this in load script.

But, I have almost hundreds of expression which include 'dept'. But the end user want to renamed as department. I don't want to rewrite all of expressions.

SV:question about alias in QV

gandalfgray — Thu, 14 Apr 2011 07:47:44 GMT

I have found that if you rename a field in the load script the change is automagically carried out in expressions in the GUI-elements like charts, tables, list boxes etc.

It seems to work both if you use

rename field Dept to Department;

or if you actually change the load statement, replacing the field name from start so to say, for example

replacing

DTab:
LOAD * INLINE [
ID, Dept
1, Sales
2, Production
3, Marketing
];

with

DTab:
LOAD * INLINE [
ID, Department
1, Sales
2, Production
3, Marketing
];

Take a copy of your .qvw and replace Dept with Department, and see if all your expressions in GUI-elements that uses Dept is replaced by Department.

question about alias in QV

Miguel_Angel_Baeyens — Thu, 14 Apr 2011 08:24:47 GMT

Hello,

Then there is an Expression Overview in the Settings menu where you can find and replace code in expressions (for example, the name of a field).

Make a backup file before using the Replace All option in that menu.

Hope that helps.