Discussion board where members can get started with Qlik Sense.
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
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
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