Change object or field title - Two titles for the same field

[#1]

Hi guys,

I have a field named [Part Parameter 01].

I retrieve that field with a loop from two different databases.

In the first db, the users use [Part Parameter 01] to store Length, while the users in the second db use [Part Parameter 01] to store Width.

Is there any chance (without separating the model into two different models) to show as title of the field "Length" while db 1 is activated and "Width" when activating db 2?

Thanks in advance,

Aldo.

[sparur]

what you mean by "activating db2" ? If you have a field with 2 values (db1 and db2) and use a listbox for switching between them, so you can to manage label in different sheet objects. For example:

in label option you can type such as:

=IF ( DBTYPE = 'db1, 'Length', 'Width')

[amars]

I guess in ur two different tables or databases there is a common field with same name but is used for different purposes. In that case u can use aliases to change the name of the field & it won't create a join in qlikview & u can use two different fields.

Regards

Amar

[#4]

Hi,

You understand the question okay. The issue is that I want to create a "generic" view where only the title of the field changes...

Is there any way to work it around?

Aldo.