How to refer display names

[admin_nasra]

Hi,

i am stuck and i don't know what to do ? i am working on a field service app in which i have registered some chemical at the time of registering company , chemicals are listed i.e CHEM-9000,CHEM-5000,CHEM-7000.

in the service log form i displayed those chemical names through Display Name using Split function

index(Split(select(System info[Chemicals],and([Customer ID]=[_thisrow].[Customer ID],[equipment] = "Chiller",[system] = [_thisrow].[system])),","),1)&"-P(kg)"

and the names are displayed properly 

FCS-800-p , FCS-700=p & FCS-500-p in the above mentioned image .

this i did in DATA section ,

now i want to use these chemical names in slices but there is no such DISPLAY settings available.

please help i cannot fix the names of chemicals as they varies from company to company.

or is there any other solution through which i can call these chemical names.

Thank in advance.

[dbaum]

---

@admin_nasra wrote:

now i want to use these chemical names in slices but there is no such DISPLAY settings available.

---

Elaborate on what you're seeking to accomplish but isn't working. The column display names that you defined apply anywhere the column is used in a view--regardless of whether the view is based directly on a table or on a slice defined for the table.

Also, in case this point is pertinent to what you're asking: Keep in mind that in the table view type a column name applies simultaneously to multiple rows and, so, it doesn't make sense to try to make its name specific to any individual row.

[admin_nasra]

Thank you Dbaum,

i am working on a service app that records the parameters and on the basis of those parameters suggests dozing of chemicals through formula.

each company has different chemicals so i canot fix the names of chemicals in our input form 

the above highlighted names are driven through 

index(Split(select(System info[Chemicals],and([Customer ID]=[_thisrow].[Customer ID],[equipment] = "Chiller",[system] = [_thisrow].[system])),","),1)&"-P(kg)"

where as the actual name of the column is CHEMICAL-A,Chemical-B

through the above mentioned formula i am picking up the chemical names from another table's column where chemicals are in this form FCS-1,FCS-2,FCS-3 .

i want to use that display name of chemicals in slices but these settings are not in slices.

please suggest .

Thank you.

[dbaum]

---

@admin_nasra wrote:

i want to use that display name of chemicals in slices but these settings are not in slices.

---

Explain what you mean by this. Again:

---

@dbaum wrote:

The column display names that you defined apply anywhere the column is used in a view--regardless of whether the view is based directly on a table or on a slice defined for the table.

---

[admin_nasra]

the above mentioned names which i highlighted is dynamic and they are not column names the actual column name is Chemical-A.

the highlighted names are driven from the below mintioned formula from a column where these names are alrady saved in comma separated values 

index(Split(select(System info[Chemicals],and([Customer ID]=[_thisrow].[Customer ID],[equipment] = "Chiller",[system] = [_thisrow].[system])),","),1)&"-P(kg)"

the above image is of column Chemical-A where display properties of column gets the name from below mentioned sheet

[TeeSee1]

As @dbaum has stated, whatever column displays you see in the original table should also be displayed in the views based on its slices.

What values are displayed in your slice view(s)?