Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
srujanaponnuru
Creator
Creator

Changing names of the field names in front end

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.

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

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' ) 

View solution in original post

3 Replies
tm_burgers
Creator III
Creator III

You could use an if(match( expression.

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

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
Contributor II
Contributor II

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