How can I get the Dimension Name as the Column Title in a Table?

[#1]

Dear,

I have a calcultated dimension in Qlik Sense. How can I get the Dimension Name as the Column Title in a Table? Now I get the formula in the Column title. For the end user that is very confusing.

I have the same issue when I select items of this Dimension. Then the Dimension Formula is shown in the Selection Field at the top of the page. The end user doesn't need to know the Formula, but he/she wants to know the Dimension Name...

How can I solve both items?

Thanks in advance.

Kind regards,

Ignace Devreese

[arulsettu]

you need to create the dimension fields with alias name in backend

for example

if you write calculated dimension in chart

if(mactch(country,'india','us','uk'),country)

in current also show like this

so in load script write like this

if(mactch(country,'india','us','uk'),country) as country

[stantrolav]

Create MasterItem. Make new dimension with calculated formula and name it as you want.

Another way is to calculate this dimension in load script.

Check this article for help:

Assets panel ‒ Qlik Sense