Changing names of the field names in front end

[srujanaponnuru]

Hi All,

I have a field called Metric_Name directly coming from backend. 

Metric_Name has field values like Revenue,ECL,RWA etc.

in front end i have pulled this Metric_Name field as a dimension in a straight table. Now i need to change the names of the field values in a straaight table. 

like Revenue as Total Revenue

ECL as Expected Cost Loans

etc..

Pleas ehelp.

[tm_burgers]

You could use an if(match( expression.

If(match(Metric_Name, 'Revenue'), 'Total Revenue', Metric_Name)

[Vegar · Accepted solution]

You could try to use a pick(match ()) technique. Like this. 

Pick(match([metric_name] , 'Revenue' ,'ECL' ,'RWA'), 'Total Revenue', 'Expected Cost Loan', 'Radio Whiskey Lima' ) 

[dieterwoestemeier]

The Generic Load would help you. Lots of examples available in the community.

Check this one: https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470