3 Replies Latest reply on Oct 16, 2018 6:38 PM by Peter Fakan

Using Aliases in Calculation

Lisa Havas Oct 16, 2018 5:03 PM

Hi,

I want to use Alias in my calculation eg:

If [Name]="Mary" then

EndIf

Where Mary is the Alias not the actual Name. This does not seem to work.

Is there a method to do this.

1. Re: Using Aliases in Calculation

ShivaRam Chennapragada Oct 16, 2018 6:21 PM (in response to Lisa Havas)

Hi Lisa,

I don't think you can use aliases in calc fields.

There are couple ideas from 2015 that I found,
https://community.tableau.com/ideas/5636
https://community.tableau.com/ideas/4264

Best,
Shiva.
Like Show 0 Likes(0)

Actions
2. Re: Using Aliases in Calculation

mursid rahman Oct 16, 2018 6:35 PM (in response to Lisa Havas)

Hi Lisa,

Could you attach your workbook?

Thank you.

Regards,
M.R
Like Show 0 Likes(0)

Actions
3. Re: Using Aliases in Calculation

Peter Fakan Oct 16, 2018 6:38 PM (in response to Lisa Havas)

Hi Lisa,

Calculated fields use the true name, not the alias so you will need to change your logic around the other way.

i.e.

If [Name] = (insert true name of field here) then '10'
end

HTH

Peter
Like Show 0 Likes(0)

Actions

Tableau Community Forums