Rename a field in my dashboard

[dolly777]

Hi All,

Rename a field every organization code VGI need to be changed in FI and every organization code VGF to FF.

pls find attached screen shots

[avinashelite]

try like this

replace(Field_name,'VGF-','FF-') as Field_name

[Anonymous]

Try

If 2 fields with separate replacements:

replace([YourFieldName],'VGI','FI') as YourFieldName

replace([YourFieldName2],'VGF','FF') as YourFieldName2

Or if its one field with 2 replacements:

replace(replace([YourFieldName],'VGI','FI'),'VGF','FF') as YourFieldName

hope this helps!

[surendraj]

Hi,

your requirement was not clear.but what my assumption is you need to change the VGI-->FI; VGF-->FF

If my assumption is correct.try this.

Replace('Team(ps)','VG','F')

If I am not corerct please clarify me.

--Surendra

[dolly777]

Hi,

I try his function but fields not changing.

,IF(LEFT(measures,3)='vgi','FI',IF(LEFT(measures,4)='vgfs','FF','VG')) AS department_key

     ,IF(LEFT(measures,3)='vgi','fi',IF(LEFT(measures,4)='vgfs','ff','vg')) AS department

     ,REPLACE(REPLACE(measures,'fi',''),'ff','') AS measures

     ,values

[avinashelite]

Qlikview is case sensitive ..check it once

IF(LEFT(measures,3)='VGI','FI',IF(LEFT(measures,4)='VGFS','FF','VG')) AS department_key

     ,IF(LEFT(measures,3)='VGI','FI',IF(LEFT(measures,4)='VGFS','FF,'vg')) AS department

     ,REPLACE(REPLACE(measures,'fi',''),'ff','') AS measures

[dolly777]

Hi Avinash,

i try same function fileds not changing

[avinashelite]

share the sample app with the data will check

[mayankraoka]

Hi Nirmala,

Please check below link this may solves your issue.

Using MapSubstring() to edit strings | Qlikview Cookbook

Regards,

Mayank