How to create a name for a calculated dimesion

[#1]

Hello

This may be a dump question but I am struggling to find the answer online.

When you create, say a long table, and you add a calculated dimension
(e.g. if(title = 'Mr', title, null())  ) and you want to rename this calculated dimension to say  'Name Mr', how could you do this??

There are no instructions on how you can rename a calculated dimension on the user manual?

I'm new to qlikview so any help would be much appreciated!!

[sunny_talwar]

May be this:

If(title = 'Mr', 'Name Mr', null())

[Siva_Sankar]

May be you can handle this in the script itself and create an alias. The use the alias name in your calculated dimension.

YourTable:

Load *,

if(title = 'Mr', title, null())  ) as 'Name Mr';

yourfield1,

yourfiled2,

...

....

from yourtable;

use now 'Name Mr' in your dimension.