topic Re: How to create a name for a calculated dimesion in QlikView

How to create a name for a calculated dimesion

Wed, 18 Nov 2015 09:21:39 GMT

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!!

Re: How to create a name for a calculated dimesion

sunny_talwar — Wed, 18 Nov 2015 09:25:53 GMT

May be this:

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

Re: How to create a name for a calculated dimesion

Siva_Sankar — Wed, 18 Nov 2015 09:38:56 GMT

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.