Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

3 Replies
Highlighted
Creator II
Creator II

You could use an if(match( expression.

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

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
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